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

PKiernan
New Contributor III

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 that can be dynamic and need to sum the results. Same would be true for AllNextInYear.

1 ACCEPTED SOLUTION

EricOsmanski
Valued Contributor

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

 

View solution in original post

2 REPLIES 2

EricOsmanski
Valued Contributor

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

 

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