Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a customers data where i want to show only the maximum and minimum values of the sales value for the bar chart. only show max and min values not show all values.
Customer | Sales |
John | 450 |
Andrew | 800 |
Mick | 600 |
Alex | 1500 |
Admin | 700 |
Ales wan | 900 |
Thanks
Take a Bar chart and
Dimension:- Customer
Expression for Max :- if(Max (TOTAL Sales)=Sales, Sum(Sales))
Expression for Min :- if(Min (TOTAL Sales)=Sales, Sum(Sales))
I dont want two expression i want to don this in single expression.
Hi,
Use the same expression provided by anand as
=if(max (TOTAL Sales)=Sales, Sum(Sales),if(min(TOTAL Sales)=Sales,Sum(Sales)))
and remove the second one
Thanks
Write this expression
Dimesnion:- Customer
Expression:- If(Min(TOTAL Sales) = Sales,sum(Sales),if(max(TOTAL Sales)=Sales, sum(Sales)) )
if(rank(sum(Sales))=1, sum(Sales),
if(rank(-sum(Sales))=1, sum(Sales)
))
Create a Straight Table
Dimension
Customer
Expression
=SUM({<Customer = {"=Rank(SUM(Sales))=1 or Rank(-SUM(Sales))=1"}>}Sales)
Thanks all its very nice i come up with next question in same.
Kindly close this thread by selecting appropriate answer if your problem solved.