Dashboard Page Selector
I've tried to post the same query yesterday, but it seems it didn't go through. I'm gonna have another try.
I'm working on creating a Variance Dashboard at Cost Center / GL level. Having those two dimensions alone would make a relative big module, but I have added couple more which is causing me a lot of troubles in terms of spacing (Page - Time, CC, Reporting ccry, comparison scenarios; Column - Line items I choose line items instead of dimensions as I would need to calculate the data based on various criterias; Rows - GL accounts. I have added for page selector comparison scenarios and "Eliminate FX impact"- this last one does not apply to my module or to any of the line items in it. I's just an IF formula referencing it. The big advantage is that will not occupy space, but the main disadvantage is that the selection is a manual input and will change it for all users.
Here is what I wanna achieve: ex: if Comparison Scenario is Actual vs Budget and "Eliminate FX Impact" is true, then variance will calculate( Actuals at Budet rate - Budget). Is there a more practical way of obtaining this, instead of applying so many dimensions? And more important, can I do it through dropdown selectors rather then Input module which will apply the same change to all users?
*** IF ITEM(VS) = VS.Actual vs Budget AND Latest Estimates.Eliminate FX Impact = TRUE*** (latest estimates being just the dummy module I used for Eliminate DX impact bolean line item)