My problem is pretty much straightforward and trivial for the vast majority of you, but I would love to have any hints on how to resolve it. I need to measure and rank the difference in product sold between $2$ years ($2020$ vs $2019$). But I must take into account two different differences for the following reasons:
- Client A in $2019$ ordered $20$k
- Client A in $2020$ ordered $100$k
Ok nice, this is a + $400$ % increase and + $80$k in absolute term.
- Client B in $2019$ ordered $1$ ML
- Client B in $2020$ ordered $1.5$ ML
Great, this is a + $50$ % increase (way less than before) and + 500k in absolute term.
This + $500$k increase is gold for me even if the percentage change is lower than + $400$ %. However, clients like Client A, who increases their spending capability so drastically must be rewarded as well in my analysis.
Do you have any idea on how to balance the two differences following my logic?