Skip to main content
P
OneStream Employee
PKiernanOneStream Employee
OneStream Employee
December 14, 2021
Solved

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

  • December 14, 2021
  • 1 reply
  • 1 view

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.

Best answer by EricOsmanski

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

 

1 reply

E
OneStream Employee
EricOsmanskiOneStream EmployeeAnswer
OneStream Employee
December 15, 2021

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

 

    P
    OneStream Employee
    PKiernanOneStream EmployeeAuthor
    OneStream Employee
    December 15, 2021

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

    Terms & ConditionsAccessibility statement