Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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