Line chart data

[#1]

Hi All,

Please help me on this.

I have added Line Chart which shows year wise sales. I tick the display "values on data point" which shows values all over. My requirement is that I want to display only Max and Min values on data point. Not all values.

Thanks in Advance

[vinieme12]

can you post a sample to demonstrate?

[#3]

hi, here 499 is highest and 153 is lowest.

[vinieme12]

Can you post a sample app with dummy data? Can't demonstrate with an Image!

Preparing examples for Upload - Reduction and Data Scrambling

[#5]

Hi

Product	Sale
Year 1	2928
Year 2	1620
Year 3	2325
Year 4	4985
Year 5	4199
Year 6	4607

Here it is data table year wise and chart. In table you can see the total sale as per year where Year 2 has lowest sale and Year 4  has highest sale. So chart showing only highest and lowest values.

Please suggest on this.

[vinieme12]

See attached App

[#7]

Yes, this is what I want. How to do this? please guide me.

[ganeshreddy]

Hi Surya,

This is how vinieme12  did it

highlighted expression in black:

=if([Sales] = Max(TOTAL Aggr(sum(Sale),Product)) or [Sales] = Min(TOTAL Aggr(sum(Sale),Product)) ,1,0)

Thanks,

Ganesh

[vinieme12]

Thanks for pointing that out to the OP