Help needed for Pivot Table

[#1]

Hi All,

In my application in one input box user is entering the No. of top recoreds he want see..Lets say top 5..

I want to dispay only top 5 records in the pivot table.

I am using QlikView 10.

So how to display conditional records in pivot table??

[Anonymous]

use calcualted dimension like this

If(Rank(aggrSum( Sales],Field))  <= 'variable', Field)

)