20 Replies Latest reply: Jul 20, 2017 6:26 AM by Mangal Kamble RSS

    Aggr Total question

    Jan-Hendrik Esterhuyse

      Hi

       

      I'm looking for the correct expression in a pivot table to get the following result

       

      image.png

      I'm asuming that I have to use the aggr function and that I also have to add total to the expression, but when I try for example the following expression

       

      =aggr(sum(total if(_year=Vyear AND accountGroupCode_mast='A' AND cat_move='MET' AND type_move='Forecast' AND accountDriver_mast='COSTING HA', value)),Fruit,Account)

       

      i get the result

       

      image.png

      Any ideas of how I should change my expression will be greatly appreciated

       

      Regards,

      Jan-Hendrik