An example how to do this in a way it will work without any need of redesign whenever something changes in future (like a new product or new player will be added).
This example is based solely on your example table (no info about when any of the sales happened are stored). So there was no need for any report sheet - all totals are calculated in product and players tables. Additionally, at top of every sheet is a subtotals row, where totals (meaningful ones) for any filtered set in table below are displayed.
In case you add some time identifier (date, week number in format YYYYWW, month number in format YYYYMM, quarter number in format YYYYQQ, or year number, etc.) into sales table, you can create additional report sheet(s), where user can determine the time period for this report, and proper totals for this time period are displayed.
Last edited by ArviLaanemets; 10-27-2025 at 11:12 AM.
|