4 Replies Latest reply: Aug 17, 2017 8:56 PM by Vishwarath Nagaraju RSS

    sum max in pivot

    Jacek Selega

      Dear Friends,

      I'm struggle with my pivot table. Problem is like that. I have a detailed table with group , item and qty.

      All i need to do is to get a max value but from a sum. I cannot find a proper way. sample.JPG

       

      As you can see i tried to use function AGGR(NODISTINCT Max(Forecast),Group) , but when i do thet i got a maximum value but from a details table and i need to know what is the maximum sum. In  case below i need to get

      for group A records 1 and 2 = 90 as a result of Item 1

      for group B records 3 and 4 = 500 as a resulit  of item 4