4 Replies Latest reply: Dec 5, 2012 4:20 AM by Dmitry Lapchenkov RSS

    aggr vs total

    Dmitry Lapchenkov



      A have table (please see atachment) and expression:


      =if(month = '201211',sum( TOTAL {<month={'201211','201210','201209'}>}Sale),0)


      I have problem with my formula. When i select only one country it works, when several - i have total sum.

      i trying use aggr function like this:


      =if(month = '201211',aggr(sum( {<month={'201211','201210','201209'}>}Sale),Country),0)


      but it it not working



      i need sum 3 month sale by Country


      Please help if you can