How to sum up Sales by each year's months?
Hello everybody,
i don't find the solution how to sum up quantities of sales by each year, with a time span of three to four years.
e.g. There are sales data from January 1st, 2014 to December 31st, 2017 in the format MMM, D YYYY
Now I want to change the Date format to JJJJ, MM in fact to be able to sum up on this operator.
My result should be the following:
Year, Month sum (Year, Month)
2014, 01 50 tons
...
2014, 12 45 tons
2015, 01 59 tons
...
2015, 12 41 tons
2016, 01 39 tons
...
2016, 12 20 tons
2017, 01 53 tons
...
2017, 12 32 tons
How can i change my Date Format to achieve this? Is it aso possible to change to a german date format as expected above?
Best regards,
Daniel
Answers
Dear Daniel,
do i see this correctly that you have data like:
1/1/2017 10
2/1/2017 20
3/1/2017 30
...
so daily sales volumes, and what to do up to monthly? If yes, use Date to Numerical to extract the Month with respect to epoch and run Aggregate with group by date afterwards. Attached is an example process to demonstrate this.
Best,
Martin
Dortmund, Germany