Hi,
I'm new to this forum. I'm trying to figure out how to build below chart using the attached spreadsheet data. The number in the chart indicates the difference between latest date and same day last week. Appreciate your help.
Thanks,
Rommel
Sorry, I attached the file before I added that filter in and then added the screenshot. I attached the twbx file with the added filter but this is how you would do it.
Create a new Calculated field called Last with the formula 'Last()'
Drag up to filter area, you will get a Filter of range of values from 0-3. Click OK
Right click on Last Filter and go to Compute Using>Table(across)
On the popup range values choose range of 0-0
If this answers the question please mark as answered so it closes the thread.
Kind Regards,
Andrew
