I can't figure out how to create a pivot table. I ...
SOLVED
I can't figure out how to create a pivot table. I want to have a column for the total sales in every month, broken out by region and product. Can you help?
The easiest way to do this is by using the aggregate rows transformation with the sum function, this will sum total sales for you. Then below, you can group by month, region and product.