Aggregate data from multiple columns

user04819

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.

 

 

 

user03357

Here's the first thing that came to my mind:

 

Full ETL:

 

Group by:

 

Join Data:

 

Select Columns:

 

 

Let me know if you have questions.

user03357

Here's the first thing that came to my mind:

 

Full ETL:

 

Group by:

 

Join Data:

 

Select Columns:

 

 

Let me know if you have questions.

user05925

Thank you! This was exactly what I was looking for!