Forum Discussion

CAOK's avatar
CAOK
New Contributor II
2 years ago

Cube-view: Calculate a column based on a calculated row

My Cube view has entities in rows. One of the rows is a sum of several entities ( E#A1+E#A2+E#A3). In the 4 columns I have Actual, Budget, Variance and Variance%. Variance and Variance % being calcul...
  • aricgresko's avatar
    aricgresko
    2 years ago

    Use Row Overrides on your two columns (Var mkr and Var %).  You should be able to just copy the exact Member Filter you have in Member Expansion 1 and paste that into the Row Overrides below.  Then just put the name of the row(s) you need to override in the Row Range.