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.

       

      Thanks

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

          Capture1.GIF

           

          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.