Grid Formulas Referencing row's or columns with Dynamically determined Members
SummaryIs there a way to set up a formula that references a row or column that uses a function to determine the members
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(,)
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.