Keep Grand Total when Filtering in a Pivot Table

[Sundance_Kid]

Hi, I have a pivot a table which includes a calculated field showing a % calculation based on two columns in the pivot table.

I want to filter out a couple of line items, but still keep the Total % field as if I had not removed anything from the table.

Is that possible?

Thanks

 

[Sundance_Kid]

I came across this video, but it doesn't seem to work because I have a calculated field showing the % and I plan to filter by the %.