Hiding the dimension in Straight Table

[#1]

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,

[sunny_talwar]

Are you just looking for the Total?

Best,

Sunny

[#3]

Hi,

Yes however for top 5 by amount

Regards,

Ajit

[sunny_talwar · Accepted solution]

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

[#5]

Thanks a ton.

Regards,

[sunny_talwar]

No Problem

Best,

Sunny