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!