Month Year - Maximum Sales

[Purushothaman]

Hi Experts,

Attached is the QVF. My Requirement is to get Each Month Year's Maximum Sales. 

Below is my output:

But What I required is to get:

Anyone, Please help!!!

Many Thanks!!

[BrunPierre]

Hi

You can do max on sales ​​and then aggregate by MonthYear.

=Aggr(Max(Sales),MonthYear)

[ogster1974 · Accepted solution]

You were just formatting your date to look like Month Year rather than creating a month year field.

Something like this

Raw1:
Load *,
//Date(Date,'MMM-YY') as MonthYear,
Month(Date) & '-'& Year(Date) as MonthYear,
Month(Date) as Month

Resident Raw;
Drop Table Raw;

Will give you what you want.

[Purushothaman]

@ogster1974  Your solution is working. Thanks for your great help!! Much Appreciated.