Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

Restricting rows in Pivot table

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

1 Reply
sunny_talwar

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