PivotTable - Adding New Columns

Dear Experts

Need help in adding 3 new columns (columns Q, R & S) into an existing PivotTable below:

ExcelForum PivotTable.png

Thank you in advance.

Here's another option, also using Power Query. I tried to make it more dynamic so that the average would recompute when there is new data added for subsequent months (eg Jul, Aug etc). My proposed solution does involve quite a number of steps, so perhaps another contributor would have better ideas on how to make this more efficient. Steps I took as follows:

1. Load Sales table and stock balance table into Power query
2. Compute Average sales separate by taking total sales of each product divided by count of number of months with data for each product. Current count is 6, but should automatically change to 7 when July data gets added in.
3. Compute Stock holding month.
4. Append sales data, average sales, stock balance, and stock holding month into 1 master table.
5. Create pivot table based on the master table in step 4.

Thank you JeteMc for your PQ. It works! But possible not to hard-code the periods in the "Inserted Average" step and also to cater to expanding data.. July month data will be added and to find the last 6 months average (Feb-Jul 2023). Thank you.

Thank you Rows&Columns for your solution. The database is huge with 5 years of sales data (and expanding) with about 3,000 products. The file will become too huge with the added Power query sheet.

Thanks JeteMc!