Hello I have a cookie company
MonthDepartmentSales
| 01.01.2023 | Center | 15 |
| 01.01.2023 | South | 22 |
| 01.01.2023 | North | 32 |
| 01.02.2023 | Center | 11 |
| 01.02.2023 | South | 12 |
| 01.02.2023 | North | 44 |
| 01.03.2023 | Center | 33 |
| 01.03.2023 | South | 21 |
| 01.03.2023 | North | 19 |
I want to filter it by year and month and:
- calculate sales by all deparments in the selected time period
- calculate the rank of each department by: amount of sold cookies by this department / maximum sold amount of cookies by single department in the selected time period * 5
Example:
In January and February the departments sold:
North: 76
South: 34
Center: 26
Maximum amount sold in this perdiod of time by one is therefore: 76
So calculated ranks of each department should be:
For North: 76/76*5 = 5
For South: 34 / 76 *5 = 2,24
For Center: 26/76*5=1,71
I can't figure out which functions I need to use.
Here is the file if You need it
https://1drv.ms/u/s!AmhVPCf3VN6XiRHGtgwsmUavlgee?e=BaEriZ
Thank You for Your help!
