Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dynamically how to send the top 10 customers (By sales) in expression panel so will get the sales of oly top 10 customers at each Zone. without selecting any zone..
BY this expression
Sum({<Customer = {"=Rank(Sum(Sales)) < 11"}>}Sales)
I am getting top10 customers at overall and based on selection.
Example: when I select North then top 10 Cust in the north are sending to expression, and when i remove selection then top 10 cust at an overall level is sending to Expression.
Added in table Year, Year Quarter , Zone, other expressions as well.
May be with the Aggr() with Rank we will get.
Hi,
I think there is no need of Rank() instead we can achieve this using Dimensions Limits.
PFA Sample
Regards
Ritesh
Hi
with function FieldSortedValue :
in a set analysis like :
Customer = {"=FieldSortedValue(Customer, -aggr(sum(sales), Zone)<=10"}
regards
Thanks for the quick Response Olivier,
Checked by your hint but still not getting a result.
*FieldSortedValue
*FirstSortedValue
sorry FirstSortedValue yes !
could you attach some data please for build exact expression
May be this
Sum({<Customer = {"=Rank(Sum(Sales)) < 11"}>}Sales)
May be this:
Using Set Analysis
Dimension = Zone
Expression = SUM({<Customer = {"=Rank(SUM(Sales),4)<=10"}>}Sales)
Use Calculated Dimension
=IF(Aggr(Rank(SUM(Sales),4),Customer)<=10,Customer)
or
=IF(Aggr(Rank(SUM(Sales),4),Zone)<=10,Zone)
Tick Suppress When Value is NULL
Expression = SUM(Sales)
Partially Correct but wanted to get top10 customers at each zone. that I could not able to get the above expression.
Dynamically how to send the top 10 customers (By sales) in expression panel so will get the sales of oly top 10 customers at each Zone. without selecting any zone..
BY this expression
Sum({<Customer = {"=Rank(Sum(Sales)) < 11"}>}Sales)
I am getting top10 customers at overall and based on selection.
Example: when I select North then top 10 Cust in the north are sending to expression, and when i remove selection then top 10 cust at an overall level is sending to Expression.