Pivot table - grand total filter

Below is a pivot table, is it possible to set filter on "Grand Total" such as no hide when "Grand Total" is 0?


ID                            A      B     C     D     E      F      G      H  Grand Total
22298175001      0      0      0      0      0      0      0      0      0
22298175002      0      0      0      0      0      0      0      0      0
22298175003      0      0      0      0      0      0      0      0      0
22298175004      0      0      2      1      1      3      0      1      8
22298175005      0      0      2      0      1      1      1      0      5
tora111Asked:
Who is Participating?
 
ProfessorJimJamCommented:
see attached file.

when you put the filter on grant total, normally the filter icon is grayed out. so what you do is, trick pivot table, select the cell next to the grant total column and then put the filter on. see in the attached file highlighted yellow cell.
Book3.xlsx
0
 
Rory ArchibaldCommented:
You can just put a value filter on the row field using Not equal 0. See attached file.
Book3--1-.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.