I have built a report in Financial Reporting Studio that consists of 3 grids: 1 for working version, 1 for reconciliation version x and 1 grid for the variance between the two.
My row dimension is entity, which has been set to "allow expansions".
I have been asked to set it up so that if the user expands a row in the first grid, the same row is automatically expanded in the second and third grid, showing the user the same members across grids (and therefore across versions).
So Grid 1 = version 1, Grid 2 = version 2 and Grid 3 = Difference between 1 and 2.
What I want is to have the user expand "Entity 1" in Grid 1 and this will automatically expand "Entity 1" in Grids 2 and 3. This way the user sees the different $$$figures for the equivalent entity in each of the versions.
If you use one grid only then "Same As" can be used. So you can have one row with version members which will have version 1 and other version 2. Then using formula row having Eval function for difference between the two rows.