Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi,
this is the solution for the ten best and what about the ten worst?
Regards
André Gomes
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
IF(Aggr(Rank(-SUM(Sales),4),Product)<=10,Product)
Hi,
please see the attached...
Hope it helps
André Gomes
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