Variance module using item subsets
Good morning team.
I have a labour model that I am looking to add a variance module to and need some assistance understanding my options. As we have a number of different versions, using native versions for the variance is inefficient and will cause the model to grow much larger than required.
The planning module currently has dimensions forecasting positions, time, versions - there are about 19 line items and only 3 are needed for variance analysis.
My optimal solution would be to create a lineitem subset of the 3 lineitems required and have the lineitems in the variance module become the versions and comparisons between them. I am having trouble achieving this and cannot find reliable information online. from what I can find the collect() function is needed, but that is more used when combining modules which I do not need.
My question is then, what sort of formula can I use to accomplish this as I wont be pointing directly at a line item in the original module. I would simply point my line item in the variance module to the version in the labour module?
Any assistance would be appreciated.