5 Replies Latest reply on Oct 27, 2016 1:13 AM by Norbert Maijoor

    How to compare a measure among different period

    Emily Z

      Hi,

       

      Need help! My source table (order margin) is as below

      OrderApr-16May-16Jun-16Jul-16Aug-16Sep-16
      A8.10%8.10%8.10%9.20%9.20%6.50%
      B12.60%17.50%17.50%17.50%17.50%13.60%
      C22.10%22.10%22.10%22.10%22.10%22.10%
      D17.80%17.80%17.80%18.80%18.80%18.80%
      E21.30%21.30%23.50%21.30%21.30%23.50%

       

       

      What I want to achieve in Tableau is to show below result

      Sep-16 vs Aug-16Sep-16 vs Jun-16
      No of Order No of Order
      Order with
        improved margin
      11
      Order with
        decreased margin
      22
      Order with
        margin - no change
      22

       

      Any idea? Thanks a lot!

       

      Emily