Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am trying to the total of top 5 items out of 8 in straight table however want to hide the dimension. The example data is -
Item | Amount |
C | 800 |
D | 654 |
A | 500 |
B | 356 |
H | 350 |
G | 300 |
F | 200 |
E | 100 |
and the required output should look like -
Total |
2960 |
Thanks in advance.
Let me know in case any details required.
Regards,
Sum of top 5 is 2660. PFA if this is what you want
Expression used: =If(Dimensionality() = 0, Sum({<Amount = {'=Rank(Sum(Amount)) <= 5'}>}Amount))
and hide the Item dimension on the presentation tab
Best,
Sunny
Are you just looking for the Total?
Best,
Sunny
Hi,
Yes however for top 5 by amount
Regards,
Ajit
Sum of top 5 is 2660. PFA if this is what you want
Expression used: =If(Dimensionality() = 0, Sum({<Amount = {'=Rank(Sum(Amount)) <= 5'}>}Amount))
and hide the Item dimension on the presentation tab
Best,
Sunny
Thanks a ton.
Regards,
No Problem
Best,
Sunny