Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)