I have two bar charts with same dimenssion but different Expression and i am showing (largest 10 values with others) in my first chart, now what I want to display in my second chart is: I should get only those 10 bars which are present in my first chart and that to in the same order.
Thanks in Advance
create a dynamic dimension with
if(aggr(rank( your formula from chart 1)<=10,dimension from chart 1)
and suspress others
Many thanks for your reply,
But this is not working..... As you mentioned i tried giving the same expression which is as below:
if(aggr(rank( Sum(if(Channel <>'Total' and (Product ='X' or Product='Y'),(Jan_Act+Feb_Act)))/1000000)<=10,Z)
Where Z= Drill down, so m not clear how to mention drill down in expression
After using this expression i am getting my first bar in both the charts same, but rest 9 bars are different.
Kindly provide me with the solution.
Use this expression. i think it will be useful
if(aggr(rank( Sum(if(Channel <>'Total' and (Product ='X' or Product='Y'),(Jan_Act+Feb_Act)))/1000000)<=10,Getcurrentfield(DrillDownGroupname)))