Grand Total - limit to Top 10 Dimension value

[#1]

    Hi All,

i have below table:

Client      Value

I have prepared Straight table and displaying Top 10 clients as per highest Value. But challenge is Grand Total in the Straight Table is showing sum of all the Clients. I want to limit the Grand Total in 'Value' Expression to sum only top 10 clients in the Straight Table

please advise

thanks,

Sukhwant

[senpradip007]

Hi.

You select to 10 limits in Dimension Limits tab and then choose Sum of Rows b under Total Mode at Expressions tab.

Hope it will help.

[MK_QSL]

You probably have used Calculated Dimension and expression as below...

Calculated Dimension =IF(Aggr(Rank(SUM(Value),4),Client)<=10,Client)

Expression = SUM(Value)

You need to Tick Suppress When Value is NULL in Dimension Tab...

Instead of above, use as below...

Dimension = Client

Expression = SUM({<Client = {"=Rank(SUM(Value),4)<=10"}>}Value)

For better understanding, please use enclosed file...

Hope this helps...

[#4]

Try this ... hope this will help u.....

[MK_QSL]

Can you close the thread by selecting appropriate answer?