Pivot Tables - Exclude Rows With Zero Balances


G

Guest

Is there a way to have pivot tables exclude rows in which the DATA amounts
are/total zero? Thanks, Bob
 
S

steven1001

try adding an extra column to the data which contains a label of 'hide
or display' where that value is determined by using a sumif calculatio
so that if the sum of all trx values for the criteria column is zer
then it gets a label of 'hide' else 'display'. Then in the pivot tabl
put the 'hide/display' label in the Page area and select onl
'Display'.

Formula would look like assuming the column headings were in row A, th
values in B and data in rows 2 to 100...
'=IF(SUMIF($A$2:$A$100 [the criteria column],$A$2:$A$100 [the criteri
column],$B$2:$B$100 [values of the criteria items]
=0,"Hide","Display")

... it worked when I tested it :-
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top