How to best design your model to facilitate variance analysis.
I have a requirement to create a model that can facilitate variance analysis like Compare CY Sales, with PY Sales and show % along with doing the same for CY Sales vs Budget.
What would be the ideal model design? Should I be create versions or should I create line items for CY, PY and Budget in the module and then calculate variance.
Would appreciate any tutorial or article on this?