I am attempting to aggregate (or subtotal) the number of cars by destination whse and then by PLA (date field). The yellow column below shows the output that I am looking to create. Beast mode? SQL data flow? ETL?
Any help here would be appreciated.
Here's the first thing that came to my mind:
Let me know if you have questions.
Thank you! This was exactly what I was looking for!