G
Guest
Good afternoon everyone.
I have perused around a bit to see if anyone has asked this question yet and
can't seem to find it or a reply.
I have zero values in a large spreadsheet (the spreadsheet is a result of an
Oracle query run on a regular basis). Without modifying the spreadsheet (to
add columns), I would like to use a Pivot Table to subtotal (count and sum)
all of the non-zero items for a given 'field'. I could accomplish this if
one of the standard subtotals (in Field Settings...) was COUNTIF, but alas it
isn't an option and I have not been successful in inserting a calculated
field (I have no idea how to do this). Any ideas?
I have perused around a bit to see if anyone has asked this question yet and
can't seem to find it or a reply.
I have zero values in a large spreadsheet (the spreadsheet is a result of an
Oracle query run on a regular basis). Without modifying the spreadsheet (to
add columns), I would like to use a Pivot Table to subtotal (count and sum)
all of the non-zero items for a given 'field'. I could accomplish this if
one of the standard subtotals (in Field Settings...) was COUNTIF, but alas it
isn't an option and I have not been successful in inserting a calculated
field (I have no idea how to do this). Any ideas?