I Have a dashboard (the screenshot is a simplified view of what I have), I need to get the previous value of a line item so I can calculate the difference. So, I need cost value from the first created date in the 2nd created date and the 2nd cost value in the 3rd created date etc (The second screen shot is to explain kind of where I want to get to)
2 respostas
You would use the LOOKUP function with an offset of -1
LOOKUP(SUM([Cost]),-1)
You will need to have the correct Compute using settings. For assistance with the settings, you need to upload a packaged workbook (twbx).
How to Anonymize Your Data for the Tableau Community Forums – data katie
James Emery
Tableau Forums Ambassador
Please click 'Select as Best' on the one reply that answers your question.
