Variable results on dashboard depending on user selection
I want to present a dashboard where the information displayed varies depending on the year/version the end user selects - see attached picture of example.
The modules that lie behind this example would be as follows:
Input Cost - user input (Dimensions - Location List, Version List, Year)
Line item 1 - formula = 'Input-Module 1'.Input Cost[LOOKUP: Filter-Module 3.Select Version, LOOKUP: Filter-Module 3.Select Year] (Dimensions - Location List)
Select Version - user input from drop down (Dimensions - none)
Select Year - user input from drop down (Dimensions - none)
The dashboards would be accessible by a number of end users, some of whom could be using the dashboards at the same time: Is there a reason for not building the model this way? The actual model would contain lists with many items and I am looking to save space in the calculation module by not having it dimensioned by Time/Version (and I would be looking to use similar method for adding other functionality like currency conversion)