straight table query in total sum

[#1]

     hi all,

while selecting top 10 in straight table, the Expression total is showing complete total rather than top 10 total. how to resolve this?

table structure is simple 1 column as client name and 2 nd column as revenue $ value

please advise

thanks

sukhwant

[#2]

Hi Sukhwant, Where you are using Client_Name in dimension use the calculated dimension as shown below: if (aggr(Rank((sum(Revenue),0,1)[client_name])<=10,[clinet_name])

[ecolomer · Accepted solution]

See this

=if(aggr((Rank(SUM(Sales),0,1)),[Branch Code],[Sales Operator])<= 5, [Branch Code])