I Need to show top 20 Application (On Amount Basis) as whichever applications having higher 20 amounts should be shown where for cases if amount is repeating like
it should should show anyone randomly.
I tried if(rank(sum(Amount))<=20,sum(Amount)) but its not showing proper result as its showing more than 20 cases with
repeating, in pivot i have other dimentions in order as
try a new expression with simply
there you will see how the ranking looks like for the whole pivot table.
Then you could add another expression to see the effect if you add e.g. 'total'
this might help you -else try to experiment a bit with 'total <Field>' depending of what you are aiming for
I have 3 Dimension in pivot table
Case (For which i did as u suggested in Top and Bottom QVW) (
If(Aggr(Rank(sum(APE_MGMT)) <= 20,Application_Num_Base1),Application_Num_Base1)
but its not showing any record ..
first create a input box and create variable then create s traitght table > in dimension table input the variable you made .
what ever no. you input in inputbox it will display as your top .
ex. input box = 20 then you straith table will display top 20
I haven't had a look at Amit's application but I think your expression should be something like this:
I think the check for ranking <=20 should be done after the Aggr() function is applied and not inside the brackets.