This content has been marked as final. Show 2 replies
Two ways are there I can suggest.
- In the script, create another column with last year data. Check :The As-Of Table for idea.
- In the UI, use pick()/match(), possibly in combination with synthetic dimension Valuelist()/Valueloop()
Both the ways have their pros and cons.