Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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.
Hi
You can do max on sales and then aggregate by MonthYear.
=Aggr(Max(Sales),MonthYear)
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.
@ogster1974 Your solution is working. Thanks for your great help!! Much Appreciated.