1 Reply Latest reply on May 27, 2016 3:24 AM by khalid norat

    Monthly sales from previous year

    Matt George

      Hi there,


      I'm stumped and for some reason, cant find the answer....


      I would like to produce a sales report that has a filter to select a year, then shows monthly sales for the year selected and the monthly sales for the previous year.


      I would like it to look like this:


      I've attached a Tableau workbook with the data.....any help much appreciated.



        • 1. Re: Monthly sales from previous year
          khalid norat



          This is the easiest way to get the visualisation you require

          Positives : You can compare any 2 or more years side by side.

          Negative you have to select multiple years in the filter.


          Hope this helps.


          If the requirement is that you only select a single year and see both current and prev year I can look into this further. It is possible just not as simple.