Forum Discussion

aneupane's avatar
aneupane
Contributor
4 years ago

CubeView - Calculate the Variance for multiple columns ( Column-by-Column)

CubeView - Calculate the Variance for multiple columns ( Column-by-Column) Hi there, I am trying to calculate variance Column-by-Column for all time members of Current Year Vs. Prior year and loo...
Cube View
  • aneupane's avatar
    aneupane
    4 years ago

    We have decided to go with UD8 member as that seems easiest from build and maintenance perspective. 

Sai_Maganti's avatar
Sai_Maganti
Contributor II
4 years ago

Another way to do this for your Option 3 would be as below in your third column

GetDataCell(Variance(T#|!SelectTimeYear!|M1,T#[YearPrior1(|!SelectTimeYear!|)]M1)):Name("Var M1"),
GetDataCell(Variance(T#|!SelectTimeYear!|M2,T#[YearPrior1(|!SelectTimeYear!|)]M2)):Name("Var M2")

and so on for all your 19 time members

So instead of creating 19 columns you could do with 19 formulas. I don't know of any other easy way to achieve this.

Best

Sai