5 Replies Latest reply: Mar 30, 2017 7:12 AM by Sunny Talwar RSS

    Partial sum with Aggr()

    Surya Teja

      Hello All,

      I have a pivot table as such

       

      Area,     Share Basis,     Time Version,     Value, Category Total

       

      Category is a field which is above Share Basis in the hierarchy, but is not shown in the pivot table..

       

      I want to do an aggregation on Category, Area and Time Version (which can be same across multiple rows) to get the Category total.

       

      I've been using the following formula.

       

      SUM(AGGR(

        SUM([Value]),

        [Category],[Area],[Time Version]

        )

        )

       

      It is not giving the expected result. It is returning a value only for one row and not the others. Is there any way I can do partial aggregations with AGGR() and how do I get the desired result in this scenario?