5 Replies Latest reply: May 23, 2012 10:53 AM by Jason Michaelides

# ::Please Help:: How to reflect top 10 products of one chart in the other with different Expression.

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.

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

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

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

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

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

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

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

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

Please detail current dimensions and expressions.