Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This can be done with set analysis and the use of Rank(). Can you post your app as it's easier to demonstrate.
Thanks,
Jason
Hi,
I am sorry to say that m not allowed to do that, but for better understanding i have attached the pics of my charts.
Thanks
Sagar Gupta
A guy Suggested me this but its not working:
if(aggr(rank( Sum(if(Channel <>'Total' and (Product ='X' or Product='Y'),(Jan_Act+Feb_Act)))/1000000)<=10,Getcurrentfield(DrillDownGroupname)))
Please detail current dimensions and expressions.
Let's say you have a simple chart at the top which is Dimension=Region and Expression=Sum(Sales). As you have done you could just have Top 10 and Others. If you want your second chart to be any expression other than Sum(Sales) but only want to show for the top 10 regions as defined by top 10 Sum(Sales) values then:
=Count({<Region={"=Rank(Sum(Sales))<=10"} >} Sales)
In this example you are counting the different Sales lines, but only for those regions ranked 10 or higher for Sum(Sales)
Hope this helps,
Jason