3 Replies Latest reply on Oct 12, 2018 10:03 AM by Meghan Tighe

    Sum a measure value on the last day

    Meghan Tighe

      Hello. I have attached a sample workbook in which three people are going traveling. Each person has different travel dates and travel expenses.

      You can see this list on the "list of expenses" sheet.

       

      I want to display on the Expenses on Last Day sheet what the expenses were for each person on their last day of travel. I have tried various window and table calcs and can not get the correct answer, which is:

       

      11 for Anna

      6 for Benjy

      20 for Meghan

       

      Then on a separate sheet, I want to be able to total the expenses, which would be 37. I need to retain the date filters that are on each sheet.

       

      I am using tableau 2018.1.3