Hi,
In our company, we are in the progress of developing a planning story & model for next year
I have added Actual 2021, 2022 and 2023, Budget 2023 and Planning 2024 to the table as columns - see screenshot below. We are using the new model for the story. In the planning story, the numbers are created using currency conversion measures with input measure control added. So for all numbers in the table, we can switch between 4 different reporting currencies we have + local currency for the specific companies.
When I have these numbers in the table, how can I create a dynamic difference column where the end-users can compare the different periods specified in the table below against Planning 2024? Is this possible, with input measure control used in the table?
Model measures:
Value Local Currency
Conversion Measures:
Value_Currency1
Value_Currency2
Value_Currency3
Value_Currency4
Value_LocalCurrency
Dimensions used:
G/L accounts
Cost Center list
Date
Version
Help is much appreciated :-)