0 Replies Latest reply: Mar 5, 2013 10:39 AM by michail R RSS

    amount of sales at the end of the month in expressions

      Good day

      Following problem, I can not count the amount of sales at the end of the month in expressions in pivot table

       

      Sum(if(Date=Aggr(Max(Date),Month),Amount,0))

      or

      Sum(Aggr(FirstSortedValue(Amount,-Date),Month))

       

      it does not work

       

      FirmID
      GoodsIDDateAmountMonth
      1101.01.20135Jan
      1231.01.20132Jan
      1428.02.20133Feb
      1228.02.20131Feb
      1105.03.20134March