Pivot Tables

[Guest]

I have a table of data that consists of well numbers, well names, volumes,
and values. For some wells the volumes and values are zero - I want to pivot
table this data, however, I want the pivot table to exclude any wells that
have zero volumes and values. Is there a criteria option in pivot tables?

 

[Dave Peterson]

I would add a helper column of formulas to the raw data.

I'd put a formula that did something like:

=if(or(volume=0,value=0),"hide","show")

(You'll do the real formula)

Then use that column in the page field.

Then just use that page field to change what I see the summary table.