Pivot & Chart help: Sales figures: rows by month & year, one col for each product

[tfield98]

I haves sales data that looks like this:

EDIT: Darn forum software messed up my formating below. I'll correct it shortly... Sorry

Date Product 1 Product 2 Product 3 Product 4 Product 5
6/17/16 $100 $38 $174
6/17/16 $38 $10
6/20/16 $100
7/12/16 $368
1/15/17 $22
1/15/17 $55

I want to create a pivot table that shows sales by month (rows) and product (5 columns)
Product 1 Product 2 Product 3 Product 4 Product 5 (and maybe Total month here)
June 2016 200 38 38 174
July 2016 368
Jan 2017 77



And then I want to create a stacked area chart that shows the cumulative sales of the products by month over the duration of data.

Can anyone give me some hints on how to do this? I've never done much with pivot tables (which I assume can feed a chart.)

I'm guessing I have to add a column to show MM/YY and the create the pivot table (which I can't figure out how to define properly) and the group by month, etc...

I'm pretty good at massaging data, adding columns, formulas, etc, which I expect I need to do to convert the MM/DD/YY to MM/YY.

May you can share some screen captures of how the pivot table is set up and the data that feeds it? Or however it's easiest to communicate.

TIA

Tom

 

[tfield98]

Here's what I'm looking for: