Grid Formulas Referencing row's or columns with Dynamically determined Members
Summary
Is there a way to set up a formula that references a row or column that uses a function to determine the membersContent
Hello All,
I am trying to figure out a way to set up a simple row formula, that references two other rows which are populated by multiple members using functions. Specifically the Formula is Difference([2],[4])
However rows 2 and 4's POV are BottomMember of "Labor". I am trying to set up a formula that will calculate the difference for each bottom level member of that hierarchy. Currently the formula just calculates the difference between the sum of all the members in rows 2 and 4.
0