I am new to Tableau and I am having trouble in creating a calculated field.
I have data like this:
I want to create a calculated field which gives the value of Flag for last month like this:
Could you please help?
LOOKUP and ATTR would help you get the Flag of the previous row.
Since they don't look for exact the previous month, so the prerequisites of this simple calculated field are,
1. There's only one row for a specific month
2. The data rows are ordered by month
Thanks Lei Chen
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...