10 Replies Latest reply on Feb 12, 2019 10:52 AM by Stephen Lam

    Only show stores which contain any sales number for certain months selected

    Stephen Lam

      Hi everyone,

       

      apologies in advance, I can't attach a workbook at this time.

       

      Based on a month drop-down filter, I only want to see stores that have sales in each of the discrete month(s) selected.

       

      -If a user selects January and March from the filter, it should display stores that contain sales numbers for both January and March

      -if a user selects only January, it should display stores that contain sales numbers for January

      -if a user selects all 12 months, it should display stores that contain sales numbers across all 12 months

       

      I've tried applying a condition to the stores filter, to make sure the sales is greater than 0 but that doesn't seem to do the trick.