GetCellvalue to sum using substitution variables

[SKVK]

Team

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

GetDataCell(T#Quarters):Name(Total)

[NidhiMangtani]

Hello,

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.

Thanks

[SKVK]

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)

[NidhiMangtani]

Please use column name in the CVC

GetDataCell(CVC(Qtrs) + 1):Name(Sum)

Thanks

[SKVK]

I did try placing the column name between the CVC( ) - Screenshot attached. But again it gives me only the result of first quarter, rather than adding 4 quarters

 

[NicoleBruno]

Hi, 

Could this work? POV could also be CV depending on which year you want to substitute.

GetDataCell(T#|PovYear|Q1+T#|PovYear|Q2+T#|PovYear|Q3+T#|PovYear|Q4):Name(Total)