Advice regarding dynamic variance dashboard

I am looking to create a dashboard where the user selects the Version/Month for the first column and then selects the comparison Version/Month for the second column (using a selection module). The dashboard would then show the selected version/months in the first 2 columns and then show the variance in the third column.

 

I do have to worry about user concurrency issues so there no 2 users clash.

 

There is a source module with results dimensioned by version/month.

I am thinking of creating the output module using a formula with SELECT/LOOKUP function to bring the appropriate figures from the source module into the first 2 columns.

However, because I need to ensure that multiple users are able to manipulate the report at same time, I would have to add the Users dimension to the output module & this would **** up the model size & I need a different way of doing this.

 

Any there any alternative solutions to this issue?

I was thinking of filtering in the source module (based on the selection module), but then how would the variance be calculated in the output module.

 

Please advise on any thoughts.

Thank you.

Tagged:

Answers