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?
Value Local Currency
Cost Center list
Help is much appreciated :-)