4 Replies Latest reply on Oct 4, 2018 5:41 AM by Archil Garishvili

    sumifs + sumifs

    Archil Garishvili

      hi I need some help with sumifs function in tabeau

      so I have data as following:

       

          

      date 1 money 1 date 2 money 2
      06/08/2018 40 06/09/201820
      29/09/2018 50 29/08/201855
      15/08/2018 60 15/09/201815
      15/09/2018 70 15/08/201825
      08/08/2018 80 08/09/201835
      07/09/2018 90 07/09/201845

       

      so I need to sum up money1 and money2, depending on the day, for example if I want report for AUGUST I should select 40, 60 and 80 from MONEY1 and 55 and 25 from MONEY2 since the corresponding dates are august.

      and my final number should be 260 (40+60+80+55+25)

       

      could you please help?