Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Regards
Sagar Gupta
Hi Sagar,
could you post an example?
Thanks
iSam
create a dynamic dimension with
if(aggr(rank( your formula from chart 1)<=10,dimension from chart 1)
and suspress others
Hi Martin,
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.
Regards
Sagar Gupta
Hi
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)))
Nahhhh,
Not working dude.
😞
Hi,
if possible uplod ur sample file ,
Hey if you don't mind, is it possible for you to come online on Skype
Regards
Sagar Gupta
Hi
My Skypeid Perumal_41
Mine sagargupta43