Hi there,
I'm trying to work out how to create 2 different pivot tables from the one table. Here is an example table below:
<tbody>
</tbody>
Ideally I want to create a pivot table where I can collate sales quantities over a month range, and then sort the data via category, or brand etc. Then another pivot table where I do the same but for the Sales$
Any ideas?
Lee
I'm trying to work out how to create 2 different pivot tables from the one table. Here is an example table below:
Product | Brand | Category | Jan Qty | Jan Sales | Feb Qty | Feb Sales | Mar Qty | Mar Sales |
Item 1 | Brand 1 | Cat 1 | 5 | $500 | 4 | $400 | 7 | $700 |
Item 2 | Brand 2 | Cat 1 | 20 | $50 | 30 | $75 | 10 | $25 |
Item 3 | Brand 2 | Cat 2 | 6 | $60 | 5 | $50 | 10 | $100 |
Item 4 | Brand 3 | Cat 2 | 10 | $250 | 30 | $750 | 10 | $250 |
<tbody>
</tbody>
Ideally I want to create a pivot table where I can collate sales quantities over a month range, and then sort the data via category, or brand etc. Then another pivot table where I do the same but for the Sales$
Any ideas?
Lee