Top 10 Calculation

[george456]

Dear Community

I am trying to calculate the Top 10 SKU into a one line output so I can use that to calculate % Contribution to Total

The syntax I am using :

sum({<

Product_Description={"=

rank(sum({<Time_Groups_Total={'MAT Rolling Folder'},Sub_Category={'Formula'},Groups - ={'S Group'},Trans_Month={'$(vMaxMonth)'}>}$(vMeasure)))<=10"}>}$(vMeasure))

The problem is I am getting a incorrect answer . I think it might be something to do with my Trans Month because the value output seems triplicated . 

What am I missing ? Can you advise

[TauseefKhan · Accepted solution]

Check this one:

Sum(
{<
Product_Description = {"=Rank(Sum({<Time_Groups_Total={'MAT Rolling Folder'}, Sub_Category={'Formula'}, Groups - ={'S Group'}, Trans_Month={'$(vMaxMonth)'}>} $(vMeasure))) <= 10"},
Time_Groups_Total = {'MAT Rolling Folder'},
Sub_Category = {'Formula'},
Groups - = {'S Group'},
Trans_Month = {'$(vMaxMonth)'}
>} $(vMeasure)
)

*****Hope this will help you to resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.******

[george456]

Hi Thanks. I get it now. I see what my error was . Appreciate your assistance/guidance