Forum Discussion

PKiernan's avatar
PKiernan
New Contributor III
4 years ago
Solved

Sum a single column in a Cube view for T#POV.AllPriorInYear

Cube View: When trying to sum a column that contains T#POV.AllPriorInYear the return is only for the first column reported. Is there a function to sum these in the cube view? I am combining scenarios...
Cube View
  • EricOsmanski's avatar
    EricOsmanski
    4 years ago

    T#POV:V#YearSumToDatePrior should work. Also T#POV:V#RestOfYear.

     

EricOsmanski's avatar
EricOsmanski
Valued Contributor
4 years ago

T#POV:V#YearSumToDatePrior should work. Also T#POV:V#RestOfYear.

 

PKiernan's avatar
PKiernan
New Contributor III
4 years ago

Thanks EO - Also used hidden column view math, which is clunky compared to the solution above.( Full Year - POV YTD).