Group Similar Date

[KKumar92]

Hi All,

Currently, I  am working on an exercise, please refer to the table below.

Month-Year	Qty
Jul-17	25
Aug-18	78
Aug-18	92
Aug-18	13
Aug-18	45
Aug-18	82
18-Sep	31
18-Sep	45
18-Sep	96
18-Sep	145
18-Sep	100

As you can see the Same Month is getting repeated again and again several times, whereas I want to have only raw

i.e. Aug-18 should show the Qty as 310.

I have used the following expression in the load script, but it did not resolve the issue.

Date(Floor(Order_Date), 'MMM/YYYY') as Order_YMonth.

Please advise on the above.

[MayilVahanan · Accepted solution]

Hi @KKumar92 

Try like below

MonthName(Floor(Order_Date)) as Month-Year

in Front end, In straight table, add below

Dim: Month-Year 

Exp: Sum(Qty)

[KKumar92]

Thanks again, @MayilVahanan for helping out with the issue. It is working..

Regards,

Kishore