Using datasets previously attached from 1-12. These include Price F1-F6 and Weight F1-F6. Each F represents a fortnightly collection for a specific quarter- March, June, September and Dec.
For each unique row (outlet with description- unique ItemID) all the Prices are summed (column values), and all the Weights are summed (column values). Then Total Price is divided by Total Weight to get Price Per Kilo for the Quarter.
This Quarterly Price Per Kilo is then appended to 13th dataset- "PVilaItemList" and can link through "ItemID".
Code has been written for this in and merged into main branch.
Is it possible to review in the same way as Tourism?
Using datasets previously attached from 1-12. These include Price F1-F6 and Weight F1-F6. Each F represents a fortnightly collection for a specific quarter- March, June, September and Dec.
For each unique row (outlet with description- unique ItemID) all the Prices are summed (column values), and all the Weights are summed (column values). Then Total Price is divided by Total Weight to get Price Per Kilo for the Quarter.
This Quarterly Price Per Kilo is then appended to 13th dataset- "PVilaItemList" and can link through "ItemID".
Code has been written for this in and merged into main branch.
Is it possible to review in the same way as Tourism?