Hi Experts,
I have a scenario where we split our departmental expenses in a ratio ( a:b:c:d) and that ratio changes by sometimes quarter over quarter or year over year. What I would like to do is to be able to plug in the Quarters/Half year/Year I want to compare as inputs or selections, my department in question as an input or selection and have the system compare what was the impact of the ratio change between the periods.
Any pointers on how do I go about thinking / implementing this?
Thanks,
Megha