10 Replies Latest reply: May 23, 2012 2:48 AM by Sagar Gupta

# How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

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.

Regards

Sagar Gupta

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Hi Sagar,

could you post an example?

Thanks

iSam

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

create a dynamic dimension with

if(aggr(rank( your formula from chart 1)<=10,dimension from chart 1)

and suspress others

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Hi Martin,

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

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

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)))

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Nahhhh,

Not working dude.

:-(

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Hi,

if possible uplod ur sample file ,

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Hey if you don't mind, is it possible for you to come online on Skype

Regards

Sagar Gupta

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Hi

My Skypeid Perumal_41

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Mine sagargupta43

• ###### How to reflect top 10 products of one chart in the other with different Expression. Very URGENT.

Dallas USA?