8 Replies Latest reply on Jul 27, 2018 6:52 AM by Simon Runc

    Replicating Excel's SUMIFS and MAX formulaes in a Tableau data source as a calculated field

    Daniel Porter

      Hi all,

       

      I'm a bit of a Tableau novice. I'm trying to replicate some logic that is relatively simple in Excel but can't figure it out in Tableau. I am trying to sum a range of values based on project name and latest date. Both criteria are crucial for the outcome.

       

      To try and explain it in more detail I have created a simple example of the logic in Excel (attached).

       

      Is anyone able to advise on the calculated field formula to copy this over, if possible?

       

      Really appreciate the help!

       

      Regards,

       

      Dan