2 Replies Latest reply on Nov 24, 2016 1:50 AM by Emily Z

    How to filter based on status of the same order in one month while showing data for both months

    Emily Z

      Hi,

       

      Got a question here.

      In my source data, one order could have different status in different months (see below)

      Order No.Status
        (Oct-2016)
      Value (Oct-2016)Status
        (Sep-2016)
      Value (Sep-2016)
      1Closed100Active100
      2Active200Active150
      3Active120Active70
      4Active150Active150
      5Closed300Active280
      6Active500Active360

       

      What I want to achieve in Tableau is to filter only based on Oct-2016 Active status while showing value for both months. Pls. advise which formula to use. Thanks a lot!

      Order No.Value (Oct-2016)Value (Sep-2016)
      2200150
      312070
      4150150
      6500360