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.




        [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?