hi
i got a pivot table where there are numerous calculated data which sums to zero as well as other values. all i require are the lines which are not Zero.
BEFORE you could use a filter option on the total column to ignore the zero but that option has now gone
how can i do this?
Bookmarks