Only Max and Min value for bar chart

[#1]

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

[its_anandrjs]

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

[#3]

I dont want two expression i want to don this in single expression.

[#4]

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

[its_anandrjs]

Thanks

Write this expression

Dimesnion:- Customer

Expression:- If(Min(TOTAL Sales) = Sales,sum(Sales),if(max(TOTAL Sales)=Sales, sum(Sales)) )

[maxgro]

if(rank(sum(Sales))=1, sum(Sales),

if(rank(-sum(Sales))=1, sum(Sales)

))

[MK_QSL]

Create a Straight Table

Dimension

Customer

Expression

=SUM({<Customer = {"=Rank(SUM(Sales))=1 or Rank(-SUM(Sales))=1"}>}Sales)

[#8]

Thanks all its very nice i come up with next question in same.

[MK_QSL]

Kindly close this thread by selecting appropriate answer if your problem solved.