Pivot row filtered count grand total spits entire data

earthworm

Active Member
Joined
May 19, 2009
Messages
368
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
When you apply filter on row section of the pivot table to get the value the pivot shows the correct filtered count .

But when you double click the grand total to view the filtered data , instead of showing that particular data pivot spits the entire data .

I have tried many attempts and reach but could not found solution . Anyone please suggest . I think this is a bug in excel.

My data in row section of pivot is is text and not numbers .
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,119,115
Messages
5,576,191
Members
412,705
Latest member
Collie
Top