Hi Tableau Community,
I have a simple tableau setup with some sample revenue by month across 3 years of data. I created a parameter (Revenue View .P) which switch between a monthly and cumulative view. I also have another parameter (Compare By .P) which when switched between "vs Last Year" or "vs Last Month" would show % difference (increase or decrease) between current hovered month vs based on the selected parameter vs Last Year same month or vs Last Month on the same year. It should work exactly the same whether the Revenue View .P is monthly or cumulative view.
How can I implement this?
good morning - there are several ways to do YoY analysis - here are 5 https://jimdehner.com/2021/08/22/5-ways-to-do-yoy-and-ytd/
the second is what I would use - and Yes you will have to do a separate calculations based on your year / month parameter selection
BTW Always include your twbx workbook when posting a question
