Peak Value to Date

[akpofureenughwu]

I have a set of data I need to visualize the peak value of the report and date of the value . I'm using the crosstable

Location	01/01/2016	02/01/2016	03/01/2016
Area 1	100	2000	50

How can I visualize the peak value in the above data set as well as the peak value date?

Regards         

[tresesco]

The more information you give the more accurate answer you get.

May be like this:

Dimension : Location

Exp (Peak Value) : Max(Value)

Exp (Date of Peak Value) : FirsSortedValue( Date, - Aggr(Sum(Value), Date,Location))

[Anil_Babu_Samineni]

What output you are expecting to see

[akpofureenughwu]

tresesco‌

Thank you for your time.... get the peak value of the set.. is Max(value) is correct

but I would love to know the date when the peak value occured ...  the second expression didnt deliver that..

regards

[akpofureenughwu]

Thank you for your time.... get the peak value of the set.. is Max(value) is correct

but I would love to know the date when the peak value occured