Forum Discussion

PKiernan's avatar
PKiernan
New Contributor III
4 years ago

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

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

     

  • EricOsmanski's avatar
    EricOsmanski
    Valued Contributor

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

     

    • PKiernan's avatar
      PKiernan
      New Contributor III

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