Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to do two pivot table : the Flop 5 and the Top 5
here is my dimension : =if(Aggr(Rank( TRS ),post)<=5,post)
For the Top it's ok i have the 5 first post,
For the flop, it put me the 5 first post in ascending order, while i wish the 5 smaller TRS.
The différents betwenn this pivot table is sorting on expression
The top
The flop
Thanks
Use this 2 formulas:
dimension : =if(Aggr(Rank( TRS ),post)<=5,post)
dimension : =if(Aggr(Rank( -TRS ),post)<=5,post)
Regards,
Mayank
Use this 2 formulas:
dimension : =if(Aggr(Rank( TRS ),post)<=5,post)
dimension : =if(Aggr(Rank( -TRS ),post)<=5,post)
Regards,
Mayank
Thanks
it's ok !