I have one single date column in my raw data. The dates range across 2018 and 2018. I have multiple products and each row represents a sale transaction. There are multiple transactions per product.
How would I go about having two columns in my pivot table, one for 2018 and another for the 2019 dates? Is this possible?
The reason I want to do this is so that I can create a pivot bar chart with 2018 and 2019 date values side by side. Eg. sale quantities for Jan 2018, Jan 2019, Feb 2018, Feb 2019 etc. What would be the best way to do this?
PS. I have thousands of rows worth of data.
In addition, I would like a to display the sale quantities for multiple products for the dates as above, eg. Jan 2018 vs Jan 2019, Feb 2018 vs Feb 2019 etc. How would I go about adding this to the pivot bar chart? Your advice on how best to remodel the data I've got would be greatly appreciated.
My raw data
What I'd like my chart to look like. Except, I'd like a breakdown for each of the products, so I can see a year on year trend:
I managed to find an example online as to how I'd like my chart to look, and therefore I'm assuming my pivot needs to look like this also: