Pivot row filtered count grand total spits entire data

[earthworm]

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 .