Hi,

I have a pivot table with 'Name' in the rows field and 'Subject' in the columns field. There are two subjects, History and Geography.

I would like to filter on all names that have, say greater than 40 marks in History, while also seeing their Geography and Grand Total marks.

How do I do that?