3 Replies Latest reply: Feb 4, 2013 7:01 AM by Vishnuram Jayaraman RSS

    Cumulative Partial Sum for Percent calc in pivot table

    Amirali Vastani

      has anyone has the RangeSum(Above(), 0, rowno(Total)) work in a percentage calc setting?

       

      Current case, is a pivot table with Product Category (vertical) against month sales on the top (across).

       

      I have an expression that compares Actual/Budget as a percent and then cumulates it and also show the Actual and Budget values. The raw values i.e. components of the percent accumulate fine in the pivot table but the Percent expression is not working for the Partial Sum enabled on the Primary dimension ProductCategory

       

      any thoughts?