Pivot Chart to show PY, YTD, Forecast figures for multiple SKUs

[seerauber]

Hi all,

I am relatively confident an answer for my question already exists, but my googlefu/excel vocabulary has proven too weak to find it. I apologize!

I am working on pulling in sales data and creating a chart. I have about 200 SKUs, and Prior Year sales data (by month), YTD sales (by month) and forecasted sales (by month) - ultimately there are additional pieces of data I'd like to pull in like conversion, traffic, ad spend, etc.

What I need to do is create a pivot table/chart that will allow me to select a product and see the performance across all the relevant measures.

Pretty basic stuff, except I can't figure out how to format my data to do this without separating each SKU and its sales data into its own table/tab. If I've explained this intelligibly, could anyone point me in a website or how-to that will help me?

Thank you!!

 

[alansidman]

Re: Help create Pivot Chart to show PY, YTD, Forecast figures for multiple SKUs

Really need to see some sample data to help you sort this out. Suggest you post a little bit of data you currently have and then what you expect it to look like. Then we can offer up some viable solution. Your current explanation is a bit vague.

 

[seerauber]

Re: Help create Pivot Chart to show PY, YTD, Forecast figures for multiple SKUs

Really need to see some sample data to help you sort this out. Suggest you post a little bit of data you currently have and then what you expect it to look like. Then we can offer up some viable solution. Your current explanation is a bit vague.

Apologies and thank you for the help. I've included sample data with an image. You can see the columns of data, and the chart. Ideally I'd like to have a single pivot chart that I can select one or more product do display, with slicers to select which data gets charted.


I have many of these individual sheets, but what I would like to be able to do going forward is combine the data for each product onto a single worksheet, and have the pivot table/chart use that single sheet as the data source. I can send an example of the raw data if necessary, though I'll have to take the time to try and anonymize it.

Is this more understandable? I feel sure that what I want is doable, I just lack the vocabulary to find the solution.

Thanks to you for your time and help!!

[TABLE="width: 1092"]
<tbody>[TR]
[TD]Date[/TD]
[TD]AD Sessions[/TD]
[TD] AMS Spend[/TD]
[TD] AMS Revenue[/TD]
[TD] Total Revenue[/TD]
[TD]Units[/TD]
[TD] Rev-AMS[/TD]
[TD] ASP[/TD]
[TD]Rev +/-[/TD]
[TD] Ad Share[/TD]
[TD]Ad Units[/TD]
[TD] Ad Conversions[/TD]
[TD]Total Sessions[/TD]
[TD] Total Conversion[/TD]
[/TR]
[TR]
[TD="align: right"]26-Jan[/TD]
[TD="align: right"]235[/TD]
[TD] $ 472.46[/TD]
[TD] $ 1,044.14[/TD]
[TD="align: right"]$1,492.61[/TD]
[TD="align: right"]62[/TD]
[TD] $ 448.47[/TD]
[TD] $ 24.07[/TD]
[TD]-[/TD]
[TD="align: right"]70.0%[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]18.5%[/TD]
[TD="align: right"]275[/TD]
[TD="align: right"]24.1%[/TD]
[/TR]
[TR]
[TD="align: right"]2-Feb[/TD]
[TD="align: right"]148[/TD]
[TD] $ 305.72[/TD]
[TD] $ 491.60[/TD]
[TD="align: right"]$894.00[/TD]
[TD="align: right"]37[/TD]
[TD] $ 402.40[/TD]
[TD] $ 24.16[/TD]
[TD="align: right"]-40.1%[/TD]
[TD="align: right"]55.0%[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]13.7%[/TD]
[TD="align: right"]295[/TD]
[TD="align: right"]25.4%[/TD]
[/TR]
[TR]
[TD="align: right"]9-Feb[/TD]
[TD="align: right"]226[/TD]
[TD] $ 430.08[/TD]
[TD] $ 877.28[/TD]
[TD="align: right"]$2,180.73[/TD]
[TD="align: right"]92[/TD]
[TD] $ 1,303.45[/TD]
[TD] $ 23.70[/TD]
[TD="align: right"]143.9%[/TD]
[TD="align: right"]40.2%[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]16.4%[/TD]
[TD="align: right"]295[/TD]
[TD="align: right"]24.3%[/TD]
[/TR]
[TR]
[TD="align: right"]16-Feb[/TD]
[TD="align: right"]188[/TD]
[TD] $ 310.54[/TD]
[TD] $ 479.60[/TD]
[TD="align: right"]$994.09[/TD]
[TD="align: right"]41[/TD]
[TD] $ 514.49[/TD]
[TD] $ 24.25[/TD]
[TD="align: right"]-54.4%[/TD]
[TD="align: right"]48.2%[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10.5%[/TD]
[TD="align: right"]315[/TD]
[TD="align: right"]26.7%[/TD]
[/TR]
[TR]
[TD="align: right"]23-Feb[/TD]
[TD="align: right"]152[/TD]
[TD] $ 274.15[/TD]
[TD] $ 801.32[/TD]
[TD="align: right"]$1,157.73[/TD]
[TD="align: right"]49[/TD]
[TD] $ 356.41[/TD]
[TD] $ 23.63[/TD]
[TD="align: right"]16.5%[/TD]
[TD="align: right"]69.2%[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]22.3%[/TD]
[TD="align: right"]325[/TD]
[TD="align: right"]29.5%[/TD]
[/TR]
[TR]
[TD="align: right"]2-Mar[/TD]
[TD="align: right"]159[/TD]
[TD] $ 341.49[/TD]
[TD] $ 747.38[/TD]
[TD="align: right"]$1,047.61[/TD]
[TD="align: right"]43[/TD]
[TD] $ 300.23[/TD]
[TD] $ 24.36[/TD]
[TD="align: right"]-9.5%[/TD]
[TD="align: right"]71.3%[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]19.3%[/TD]
[TD="align: right"]337[/TD]
[TD="align: right"]27.6%[/TD]
[/TR]
[TR]
[TD="align: right"]9-Mar[/TD]
[TD="align: right"]183[/TD]
[TD] $ 418.86[/TD]
[TD] $ 647.44[/TD]
[TD="align: right"]$1,036.50[/TD]
[TD="align: right"]43[/TD]
[TD] $ 389.06[/TD]
[TD] $ 24.10[/TD]
[TD="align: right"]-1.1%[/TD]
[TD="align: right"]62.5%[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]14.7%[/TD]
[TD="align: right"]349[/TD]
[TD="align: right"]29.8%[/TD]
[/TR]
[TR]
[TD="align: right"]16-Mar[/TD]
[TD="align: right"]155[/TD]
[TD] $ 352.07[/TD]
[TD] $ 917.24[/TD]
[TD="align: right"]$986.99[/TD]
[TD="align: right"]41[/TD]
[TD] $ 69.75[/TD]
[TD] $ 24.07[/TD]
[TD="align: right"]-4.8%[/TD]
[TD="align: right"]92.9%[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]24.6%[/TD]
[TD="align: right"]361[/TD]
[TD="align: right"]30.2%[/TD]
[/TR]
[TR]
[TD="align: right"]23-Mar[/TD]
[TD="align: right"]173[/TD]
[TD] $ 437.68[/TD]
[TD] $ 1,019.16[/TD]
[TD="align: right"]$1,305.32[/TD]
[TD="align: right"]54[/TD]
[TD] $ 286.16[/TD]
[TD] $ 24.17[/TD]
[TD="align: right"]32.3%[/TD]
[TD="align: right"]78.1%[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]24.4%[/TD]
[TD="align: right"]373[/TD]
[TD="align: right"]29.5%[/TD]
[/TR]
[TR]
[TD="align: right"]30-Mar[/TD]
[TD="align: right"]208[/TD]
[TD] $ 484.98[/TD]
[TD] $ 1,072.12[/TD]
[TD="align: right"]$1,707.66[/TD]
[TD="align: right"]71[/TD]
[TD] $ 635.54[/TD]
[TD] $ 24.05[/TD]
[TD="align: right"]30.8%[/TD]
[TD="align: right"]62.8%[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]21.4%[/TD]
[TD="align: right"]385[/TD]
[TD="align: right"]30.9%[/TD]
[/TR]
[TR]
[TD="align: right"]6-Apr[/TD]
[TD="align: right"]377[/TD]
[TD] $ 747.37[/TD]
[TD] $ 1,357.88[/TD]
[TD="align: right"]$2,291.68[/TD]
[TD="align: right"]95[/TD]
[TD] $ 933.80[/TD]
[TD] $ 24.12[/TD]
[TD="align: right"]34.2%[/TD]
[TD="align: right"]59.3%[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]14.9%[/TD]
[TD="align: right"]397[/TD]
[TD="align: right"]31.2%[/TD]
[/TR]
[TR]
[TD="align: right"]13-Apr[/TD]
[TD="align: right"]353[/TD]
[TD] $ 629.99[/TD]
[TD] $ 1,565.68[/TD]
[TD="align: right"]$3,086.60[/TD]
[TD="align: right"]128[/TD]
[TD] $ 1,520.92[/TD]
[TD] $ 24.11[/TD]
[TD="align: right"]34.7%[/TD]
[TD="align: right"]50.7%[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]18.4%[/TD]
[TD="align: right"]409[/TD]
[TD="align: right"]32.1%[/TD]
[/TR]
[TR]
[TD="align: right"]20-Apr[/TD]
[TD="align: right"]431[/TD]
[TD] $ 902.00[/TD]
[TD] $ 2,186.00[/TD]
[TD] $ 4,054.00[/TD]
[TD="align: right"]168[/TD]
[TD] $ 1,868.00[/TD]
[TD] $ 24.13[/TD]
[TD="align: right"]31.3%[/TD]
[TD="align: right"]53.9%[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]21.0%[/TD]
[TD="align: right"]421[/TD]
[TD="align: right"]28.9%[/TD]
[/TR]
[TR]
[TD="align: right"]27-Apr[/TD]
[TD="align: right"]488[/TD]
[TD] $ 1,052.00[/TD]
[TD] $ 2,006.00[/TD]
[TD] $ 3,884.00[/TD]
[TD="align: right"]161[/TD]
[TD] $ 1,878.00[/TD]
[TD] $ 24.12[/TD]
[TD="align: right"]-4.2%[/TD]
[TD="align: right"]51.6%[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]17.0%[/TD]
[TD="align: right"]433[/TD]
[TD="align: right"]33.3%[/TD]
[/TR]
[TR]
[TD="align: right"]4-May[/TD]
[TD="align: right"]987[/TD]
[TD] $ 2,541.00[/TD]
[TD] $ 4,373.00[/TD]
[TD] $ 5,288.00[/TD]
[TD="align: right"]218[/TD]
[TD] $ 915.00[/TD]
[TD] $ 24.26[/TD]
[TD="align: right"]36.1%[/TD]
[TD="align: right"]82.7%[/TD]
[TD="align: right"]180[/TD]
[TD="align: right"]18.3%[/TD]
[TD="align: right"]445[/TD]
[TD="align: right"]33.8%[/TD]
[/TR]
</tbody>[/TABLE]

 

[GR00007]

Re: Help create Pivot Chart to show PY, YTD, Forecast figures for multiple SKUs

Your sample data has a few challenges:
- The row date is by week and you want to report monthly, any thoughts on how to split a week between months correctly
- Don't see a product to select
Suggestions:
- Pivot the data then use slice & dice to add product selection and any other filter criteria desired (it has to be in the raw data though)
- In pivot recalculate percentages based on raw data - using percentages to calculate percentages is a good way to cause problems
- You can add 'helper' columns in the raw data to delineate the year/month however you want, or utilize Pivot's calculated field to create what you need.

 

[seerauber]

Re: Help create Pivot Chart to show PY, YTD, Forecast figures for multiple SKUs

Your sample data has a few challenges:
- The row date is by week and you want to report monthly, any thoughts on how to split a week between months correctly
- Don't see a product to select
Suggestions:
- Pivot the data then use slice & dice to add product selection and any other filter criteria desired (it has to be in the raw data though)
- In pivot recalculate percentages based on raw data - using percentages to calculate percentages is a good way to cause problems
- You can add 'helper' columns in the raw data to delineate the year/month however you want, or utilize Pivot's calculated field to create what you need.

Thank you!

A big follow up question I have - is there a way to structure my data within a single table so that I can create a pivot table/pivot chart as you describe?

Currently I have around 200 worksheets containing data similar to my example above - one for each product. I actually manually construct that data from two different raw sources (sales data dump, marketing data dump. Could I just maintain two worksheets for each raw data source and somehow structure the Pivot Table or Pivot Chart to sum up by sku and time period, and draw the above graph based on a SKU slicer?

There is not any actual date-data within my raw data - I manually pull the data based on specified range, so I'll probably have to manually input the date column myself no matter what..

Below examples of my two raw data sources - each SKU will have a record for each time period (be it a week, or month, etc.)

​MARKETING DATA
[TABLE="width: 1678"]
<tbody>[TR]
[TD]Advertised SKU[/TD]
[TD]Impressions[/TD]
[TD]Clicks[/TD]
[TD](CTR)[/TD]
[TD](CPC)[/TD]
[TD]Spend[/TD]
[TD]7 Day Total Sales[/TD]
[TD](ACoS)[/TD]
[TD](RoAS)[/TD]
[TD]7 Day Total Orders (#)[/TD]
[TD]7 Day Total Units (#)[/TD]
[TD]7 Day Conversion Rate[/TD]
[/TR]
[TR]
[TD]N5-DUMMY[/TD]
[TD="align: right"]71411[/TD]
[TD="align: right"]194[/TD]
[TD="align: right"]0.2717%[/TD]
[TD="align: right"]$ 3.33[/TD]
[TD="align: right"]$ 645.67[/TD]
[TD="align: right"]$ 485.62[/TD]
[TD="align: right"]132.9579%[/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]9.7938%[/TD]
[/TR]
[TR]
[TD]1C-DUMMY[/TD]
[TD="align: right"]51074[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]0.2095%[/TD]
[TD="align: right"]$ 2.66[/TD]
[TD="align: right"]$ 284.71[/TD]
[TD="align: right"]$ 389.70[/TD]
[TD="align: right"]73.0588%[/TD]
[TD="align: right"]1.37[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]13.0841%[/TD]
[/TR]
[TR]
[TD]T4-DUMMY[/TD]
[TD="align: right"]67346[/TD]
[TD="align: right"]212[/TD]
[TD="align: right"]0.3148%[/TD]
[TD="align: right"]$ 2.17[/TD]
[TD="align: right"]$ 459.53[/TD]
[TD="align: right"]$ 901.26[/TD]
[TD="align: right"]50.9875%[/TD]
[TD="align: right"]1.96[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]17.4528%[/TD]
[/TR]
</tbody>[/TABLE]

SALES DATA
[TABLE="width: 1380"]
<tbody>[TR]
[TD]Title[/TD]
[TD]SKU[/TD]
[TD]Sessions[/TD]
[TD]Session Percentage[/TD]
[TD]Page Views[/TD]
[TD]Page Views Percentage[/TD]
[TD]Buy Box Percentage[/TD]
[TD]Units Ordered[/TD]
[TD]Unit Session Percentage[/TD]
[TD]Ordered Product Sales[/TD]
[TD]Total Order Items[/TD]
[/TR]
[TR]
[TD]Product 1[/TD]
[TD]T4-DUMMY[/TD]
[TD="align: right"]292[/TD]
[TD="align: right"]20.10%[/TD]
[TD="align: right"]394[/TD]
[TD="align: right"]20.25%[/TD]
[TD="align: right"]97%[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]31.85%[/TD]
[TD="align: right"]$1,588.69[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]Product 2[/TD]
[TD]1C-DUMMY[/TD]
[TD="align: right"]254[/TD]
[TD="align: right"]17.48%[/TD]
[TD="align: right"]341[/TD]
[TD="align: right"]17.52%[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]24.41%[/TD]
[TD="align: right"]$1,492.61[/TD]
[TD="align: right"]62[/TD]
[/TR]
[TR]
[TD]Product 3[/TD]
[TD]N5-DUMMY[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]13.76%[/TD]
[TD="align: right"]265[/TD]
[TD="align: right"]13.62%[/TD]
[TD="align: right"]99%[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]21.50%[/TD]
[TD="align: right"]$1,124.03[/TD]
[TD="align: right"]42
[/TD]
[/TR]
</tbody>[/TABLE]

 

[GR00007]

Re: Help create Pivot Chart to show PY, YTD, Forecast figures for multiple SKUs

It appears as though the examples given are actually reports that you would like to have an overall view of for analysis.
If that is so, do you have a way of getting a dump of the real raw data:
Marketing: (for import to Excel)
- Date (month, day, and year - or year, week - or whatever criteria to report - consistent with Sales Data extract) Aggregate marketing data on this criteria
- SKU
- Impressions, clicks, CPC, Spend, Sales, Order count, Unit count, PLUS know the calculation necessary for CTR, ACoS, RoAS values
Sales: (for import to Excel)
- Date (month, day, and year - or year, week - or whatever criteria to report - consistent with Marketing Data extract) Aggregate sales data on this criteria
- SKU
- Title (if wanted) Sessions, Page views, Units Ordered, Sales, Items PLUS know the calculation necessary for percentages
For both of these, I'd suggest gather data by date (month, day, year) and let the pivot summarize data and calculate percentages - giving flexibility for analysis.
Make a new sheet that will use data from sales and marketing that can then be the data source for your pivot and subsequent slice and dice.

 

[seerauber]

Re: Help create Pivot Chart to show PY, YTD, Forecast figures for multiple SKUs

It appears as though the examples given are actually reports that you would like to have an overall view of for analysis.
If that is so, do you have a way of getting a dump of the real raw data:
Marketing: (for import to Excel)
- Date (month, day, and year - or year, week - or whatever criteria to report - consistent with Sales Data extract) Aggregate marketing data on this criteria
- SKU
- Impressions, clicks, CPC, Spend, Sales, Order count, Unit count, PLUS know the calculation necessary for CTR, ACoS, RoAS values
Sales: (for import to Excel)
- Date (month, day, and year - or year, week - or whatever criteria to report - consistent with Marketing Data extract) Aggregate sales data on this criteria
- SKU
- Title (if wanted) Sessions, Page views, Units Ordered, Sales, Items PLUS know the calculation necessary for percentages
For both of these, I'd suggest gather data by date (month, day, year) and let the pivot summarize data and calculate percentages - giving flexibility for analysis.
Make a new sheet that will use data from sales and marketing that can then be the data source for your pivot and subsequent slice and dice.

Thank you again GR00007,

I don't mean to badger you with follow up questions, but can you advise me or point me in the direction of a resource that could walk me through what you suggest?

I am envisioning this process:

1) Download weekly data dumps of Sales and Marketing raw data
2) Adding Date date to each (probably just a "Week Ending" Column)
3) Appending each successive weekly dump to an aggregate "Sales" and aggregate "Marketing" worksheet
4) Combing both files into a pivot table

I am not skilled at Pivot Tables (yet! ) so I am unsure of how to ensure the pivot table gathers the data by week/month/year (ideally this would be user-selectable with a slicer or something). Further, in the marketing data dump, there are 2 or more rows for each SKU - so I need to figure out how to make the pivot table both gathers the SKU level data by week, while also summing data per SKU/Week from the marketing data dump.

Below is an example again for one SKU/1 week of marketing raw data dump:

[TABLE="width: 2582"]
<tbody>[TR]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Portfolio name[/TD]
[TD]Currency[/TD]
[TD]Campaign Name[/TD]
[TD]Ad Group Name[/TD]
[TD]Advertised SKU[/TD]
[TD]Advertised ASIN[/TD]
[TD]Impressions[/TD]
[TD]Clicks[/TD]
[TD](CTR)[/TD]
[TD](CPC)[/TD]
[TD]Spend[/TD]
[TD]7 Day Total Sales[/TD]
[TD](ACoS)[/TD]
[TD](RoAS)[/TD]
[TD]7 Day Total Orders (#)[/TD]
[TD]7 Day Total Units (#)[/TD]
[/TR]
[TR]
[TD="align: right"]May 05, 2019[/TD]
[TD="align: right"]May 11, 2019[/TD]
[TD]Not grouped[/TD]
[TD]USD[/TD]
[TD]DUMMY | Manual | CPC[/TD]
[TD]0J-M0VS-DUMMY[/TD]
[TD]SKU 1[/TD]
[TD]ASIN 1[/TD]
[TD="align: right"]86448[/TD]
[TD="align: right"]143[/TD]
[TD="align: right"]0.1654%[/TD]
[TD="align: right"]$ 2.44[/TD]
[TD="align: right"]$ 348.68[/TD]
[TD="align: right"]$ 462.62[/TD]
[TD="align: right"]75.3707%[/TD]
[TD="align: right"]1.33[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD="align: right"]May 05, 2019[/TD]
[TD="align: right"]May 11, 2019[/TD]
[TD]Not grouped[/TD]
[TD]USD[/TD]
[TD]DUMMY | Auto | CPC[/TD]
[TD]0J-M0VS-DUMMY[/TD]
[TD]SKU 1[/TD]
[TD]ASIN 1[/TD]
[TD="align: right"]977[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.5118%[/TD]
[TD="align: right"]$ 0.37[/TD]
[TD="align: right"]$ 1.85[/TD]
[TD="align: right"]$ 0.00[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]May 05, 2019[/TD]
[TD="align: right"]May 11, 2019[/TD]
[TD]Not grouped[/TD]
[TD]USD[/TD]
[TD]DUMMY | Manual | CPC[/TD]
[TD]0J-M0VS-DUMMY[/TD]
[TD]SKU 1[/TD]
[TD]ASIN 1[/TD]
[TD="align: right"]370[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1.0811%[/TD]
[TD="align: right"]$ 0.93[/TD]
[TD="align: right"]$ 3.70[/TD]
[TD="align: right"]$ 73.94[/TD]
[TD="align: right"]5.0041%[/TD]
[TD="align: right"]19.98[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]May 05, 2019[/TD]
[TD="align: right"]May 11, 2019[/TD]
[TD]Not grouped[/TD]
[TD]USD[/TD]
[TD]DUMMY | Manual | PAT | CPC[/TD]
[TD]Product Targeting[/TD]
[TD]SKU 1[/TD]
[TD]ASIN 1[/TD]
[TD="align: right"]15689[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]0.0701%[/TD]
[TD="align: right"]$ 1.45[/TD]
[TD="align: right"]$ 15.97[/TD]
[TD="align: right"]$ 0.00[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[GR00007]

Re: Help create Pivot Chart to show PY, YTD, Forecast figures for multiple SKUs

Looks good, and appending data weekly to the same sheets would require just a refresh to reflect the addition on the pivot.
There are many tutorials on pivots, this is just one with a business focus including sales and commissions: https://excelwithbusiness.com/blog/pivot-table-how-to-guide/
...this one gets into details: https://exceljet.net/excel-pivot-tables --- many many others, I would suggest start simple then dive into enhancements to aid analysis.
You mention monthly - do you have a 4/4/5 calendar - that's one where whole weeks are grouped into two four week months followed by a five week month (364 days - having to add a week about every seven years) There's pluses and minuses to that, it's up to your accountants to decide. You could have a calendar tab with a lookup by date to find the associated month.