4 Replies Latest reply on Jun 1, 2017 4:56 AM by Okechukwu Ossai

    Multiple Filter Application for Totals

    Trent McKenzie

      How would I be able to filter all Detroit inbound and outbound results for a Yes compliance? If I select to filter Detroit on inbound it ignores outbound Detroit values because there were not any inbound shipments going from the same place.

       

      My end result would be Detroit: total yes compliance = 3 ; total no compliance = 4; overall count = 7

      I would, in the end, have to find total compliance for each location and other analysis of course.

       

      Thanks for any help!

       

      InboundOutboundCompliant
      DetroitNew YorkYes
      DetroitNew YorkNo
      DetroitNew YorkYes
      DetroitNew YorkNo
      DetroitNew YorkNo
      CincinnatiNew YorkNo
      CincinnatiLas VegasYes
      CincinnatiLas VegasYes
      CincinnatiDetroitYes
      CincinnatiDetroitNo
      CincinnatiHoustonNo
      CincinnatiHoustonYes
      CincinnatiTampaYes
      New YorkHoustonYes
      New YorkTampaNo
      New YorkNew JerseyNo
      New YorkToronto

      No