Display the highest value of sales only

[akpofureenughwu]

Good day sir,

I have a set of data that I am working on. I need to display the highest sales value only

Please how can I achieve that?

Regards

Akpofure

[Anil_Babu_Samineni]

Do you have Data set with you, Would you share that data and tell us the Expected result and where you are doing this?

[akpofureenughwu]

Hello Babu,

I wold love to know the highest sales for each location as well as the total states..

As well as monthly high, quarter high .. possible weekly (*can it be possible)

Regards

[tresesco]

Did you try max() like:  =Max(Sales)  ?

[MK_QSL]

Highest Sales with respect to what?

If you want highest sales for country, you can do something like below.

=Max(Aggr(SUM(Sales),Country))

or

=Max(Total Aggr(SUM(Sales),Country))

[Anil_Babu_Samineni]

From given data what are you expecting? May be these?

1) Max(Aggr(Sum(sales), location))

2) Max(Aggr(Sum(sales), states)) ......