Total Top10 Multiple Dimension

[kanonkop]

Good Day Everyone,

I am struggling trying to find a way to do resolve this TOTAL Top 10 value calculation. I require this TOTAL value in order to calculate the % value for the top ten list.

The Top 10 Formula I used:

=if(rank(total sum(Value1))<=10,sum(Value1))

Herewith a sample of the data. In the last column, I need this value to be 370 as that is the total of the top 10.

I have tried formulas like below for the TOTAL TOP 10 Value...with different combinations of dimensions ect. 

=Sum(Total {<Dimension_1 = {"=Rank(Sum(Value1))<=10"} >}Value1)
=sum(total Aggr(if(Rank(aggr(Sum(Value1),Dimension_1,Dimension_2,Dimension_3),4,1) <=10,Sum(Value1),0),Dimension_1,Dimension_2,Dimension_3))
=sum(total Aggr(if(Rank(Sum(Value1),3,1) <=10,Sum(Value1),0),Dimension_1,Dimension_2,Dimension_3))

Spoiler

Load * Inline [
Dimension_1, Dimension_2, Dimension_3, Value1, Value2,
Text Value 1, Text Option 1, GW, 70, 7,
Text Value 1, Text Option 2, GW, 85, 6,
Text Value 2, Text Option 3, GW, 35, 3,
Text Value 3, Text Option 4, GW, 40, 3,
Text Value 4, Text Option 4, GW, 30, 2,
Text Value 1, Text Option 5, GW, 30, 2,
Text Value 1, Text Option 6, GW, 30, 2,
Text Value 3, Text Option 7, GW, 20, 2,
Text Value 2, Text Option 8, GW, 15, 1,
Text Value 3, Text Option 9, GW, 15, 1,
Text Value 5, Text Option 10, GW, 10, 1,
];

Hoping it is something I just miss and easy to resolve.

Thanks and Regards,

Kanon

[tresesco · Accepted solution]

Try:

Sum( total Aggr( if(rank(TOTAL sum(Value1))<=10,sum(Value1)), Dimension_1, Dimension_2, Dimension_3))

[kanonkop]

Good Day Tresesco,

Thank you soo much, I have missed the TOTAL in the rank section it seems...