The idea is basically the same. I want to see first Actual, Budget and then dynamic FC version depending on page selector. After that I want to see difference between Bud and selected FC version.
I didn’t figure it out how to do it. I’ve done the calculated item and linked it to the page selectors, but I can still see all FC versions and I don’t know how to hide them (=switch based on Page selector (as in original article)).
Thanks!
Page 1 / 1
Hi Alina,
This is possible with the use of Item variables and a calculated item. I have a simple example below.
First, create a simple metric with a version, department and year dimensions and add some sample data. Pivot your view so that the metric label and year are in the Pages, Version is in the Columns, and Department is in the Rows.
Next, right click on the Version column header, and create a Custom calculation Calculated Item. Give it a display name, change the position to After "All Items" in the dropdown and then open the Item A dropdown and select Create Item Variable.
Create two Item Variables on the Version dimension - I called mine Compare A and Compare B. Select Variable type "Static" and then "Allow Changes" on both variables. Choose a starting variable value for each (ideally not the same one) and click Save.
Map Item and and Item B to your Compare A & B variables and click Apply. You will now notice two Compare page selectors that allow you to change which versions are being compared in the Variance Calculated item.
To get an ever better user experience, you can open the Pivot panel and add the Version dimension into the Pages as well. Then click the Pages options button next to the page selectors. Change the Default Items for Version from All to your two Compare variables and click Apply.
Your Versions should be filtered to the Compare variable page selectors.
Hi @Jake
Thanks for soo detailed explanation. I’ve been able to do so but I still have many FC versions in the columns (see screenshot)
So, delta changes depending on the version I select, but what I want to see is only one FC version (versions called P in this model). So, based on this screenshot it should be Actual, P05 and Delta. And if I change Page selector from P05 to P06, then Actual, P06 and Delta.
The link I shared before has a GIF with the functionality like this.
Hi Alina,
I think you need to make sure that you are including the Version dimension in your pages in the pivot panel, and then run the page options step above (Set the “Default Items” for the Version page selector to the variables created).
