2 Replies Latest reply on Aug 1, 2018 9:53 PM by Jarrad Redmond

    Prior Year Sales - Australian fiscal calendar

    Jarrad Redmond

      Evening all,

       

      I'm still fairly new to Tableau so excuse my ignorance if this has already been answered.

       

      Here in Australia we operate on a July to June fiscal year. What I'm struggling with is trying to get a prior year sales total for FY2017-18.

       

      From there is it then possible to plot this on a stacked line chart to compare YoY?

       

      I've attached a quick through together using the Superstore data, using order date. this date has been changed in default properties to reflect the Australian fiscal date. I've also created calculated fields for Current and Prior years. I would prefer this to be dynamic if possible based on the year selected for order date.

       

      Thanks in advance for any suggestions.

       

      Jarrad