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

# Sum a measure value on the last day

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

• ###### 1. Re: Sum a measure value on the last day

please see the attached - this will return

this in detail

and in summary

jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: Sum a measure value on the last day

please use below calculation and let me know if this helps and place the field to view

IF [Date]=[Last Travel Date] THEN [Expenses] END