Select a highest value in set analysis

[jolivares]

Someone help me...

I want to select a high value in a set analysis even a group of value is selected or not, see the example attached.

Thanks.

[francisvandergr]

You want the month and day of today ?

[jolivares · Accepted solution]

Yes, as you see in the example it no work as I expected

[Anonymous]

Hi J.

If your sales are already by day then you don't need SUM.
Isn't just " MAX(Sales) " Enough in this case?

It retruns the highest Sales (which is the day total) for each dimension (=division)

Check the attachment, hope it helps.

[Anonymous]

Sorry I misread, You want the higest DAY not the Higest Sales.

You are making it to hard on yourself by using YEAR and Month and DAY.
Making just one DATE field, makes it a lot easier.

Check the files and let me know if this helps.