Restricting rows in Pivot table

[mhmmd_srf]

Hi All,

I have a pivot table like below. I want to show always last 5 rows.

Can you please help me to do that.

Thanks,

Sarif

[sunny_talwar · Accepted solution]

May be use a calculated dimension

If(Consolidated >= Max(TOTAL Consolidated, 5), Consolidated)

and then check 'Suppress When Value Is Null' on the dimensions tab