I've got some data in a Google Drive spreadsheet that I want to run a pivot table on. There are 3 columns
Element, Cost, Omit as per screenshot below
I want to summarise the cost by element, but exclude any lines that have the value "omit" in the column "omit"
I've started to setup the pivot table, to summarise the cost by element which works fine, but I can't work out how to exclude the "omit" items in the pivot table summary.
To help, I've made a shared Google spreadsheet here, please go to
File > make a copy if you would like to use it. Link to google drive spreadsheet : https://docs.google.com/spreadsheets/d/1gvsg8shqWJnK_zRxQUFcWDwJxE1ym6lSE35fSAqpx8s/edit#gid=0