top products ?

[#1]

HI All,

I need to show top 10 products based on Sales Amount..

I need to Show % of Sales Amount as well as Gross Margin %.. ?

and also Units in lakhs I want to show the Sales Amount is this possible,..

Can any one share Some example related to this with this bar chart..

Regards,

Heather

[MK_QSL]

Create a Straight Table

Dimension

Calculated Dimension

IF(Aggr(Rank(SUM(Sales),4),Product)<=10,Product)

Tick Suppress When Value is NULL

Expression

1) SUM(Sales)

2) SUM(Sales) / SUM(Total Sales)

3) SUM(Sales)

     TICK RELATIVE CHECKBOX

4) NUM((SUM(Sales)-SUM(Purchase))/SUM(Sales),'#,0.00%')

5) COUNT(Units)

[agomes1971]

Hi,

this is the solution for the ten best and what about the ten worst?

Regards

André Gomes

[#4]

I need to show Sales amount in Lakhs..

and also I have to create Bar chart & Pie charts..

Can you share with some example, So that it will be clear to me..

Regards,

Kacy

[MK_QSL]

IF(Aggr(Rank(-SUM(Sales),4),Product)<=10,Product)

[ashfaq_haseeb]

HI,

Check this.

Re: Bottom 5 values

Regards

ASHFAQ

[agomes1971]

Hi,

please see the attached...

Hope it helps

André Gomes

[its_anandrjs]

Hi,

For Top 10 results

Dimension:-

=if(aggr(rank(sum(Value)),Dimension)<=10,Dimension) //And tick on suppress when value is null

Expression:-

Sum(Value)

For Top worst

=if(aggr(rank( - sum(Value)),Dimension)<=10,Dimension)  //And tick on suppress when value is null

Expression:-

Sum(Value)

Note:- By using same dimension and expression you can change the chart type and use the Pie and Bar charts and also straight chart.

Regards

Anand