Is there a way where i can sum the columns/data using Variables.
Example: Instead of using GetDataCell(T#2021M1+T#2021M2):Name(Total) , can i use some kind of variable which calculates based on POV/Cube view
Please explore using CVC on your cube view columns:
GetDataCell(CVC(SomeColumnName) + CVC(SomeOtherColumnName)):Name(Header Name)
GetDataCell(CVC(Col1) - CVC(Col2)):Name(Variance)
Examples of Column Math:
GetDataCell(CVC(Col1) + 1):Name(Column Plus One)
GetDataCell(CVC(Col1) * (-1)):Name(Column with Sign Flipped)
Hope this helps.
Thank you. It works fine only when you the columns explicitly have it the Cube Views.
In the first column which i have named as "Qtrs" have a time formula as "T#2021.Quarters" which in Data explorer expands and gives me all the quarters of 2021 (Q1, Q2, Q3, Q4).
If i use your suggested formula in a new column, it gives only the data of Q1
Formula used - GetDataCell(CVC(T#2021.Quarters) + 1):Name(Sum)