Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this
=if(aggr((Rank(SUM(Sales),0,1)),[Branch Code],[Sales Operator])<= 5, [Branch Code])
An example to see ....
Hello Sukhwant,
Do You have some image or sample data ?
Morandi
sorry no developer license, so can't open attachment
are you using dimension limit for top?
hi ,
data can be
Client name value
1 50
2 40
3 30
4 20
5 10
6 50
so when i say top 5 in presentation tab, and expression of value as "sum of rows", i should get total as 150, but i am getting 200
please advise
thanks
different ways to get top
Properties - presentation - max num (1-100) - 5
Hi,
Try
sum(aggr(rank(revenue)<=5,revenue))
Regards
KC
Use calculated dimension to restrict number of dimensions which will give you correct total
=If(Aggr(Rank(Sum(value)) <= 5,[Client name]),[Client name])