4 Replies Latest reply on Aug 25, 2017 7:18 AM by Alysse Mea

    create 1 filter from dimensions

    Alysse Mea

      I need to create a filter to have 5 options: All, Mail 1 Rec, Mail 2 Rec and Mail 3 Rec and No Mail. If All is selected, all 9 records will be returned. If Mail 1 Rec then  6 records, Mail 2 Rec then 3 records, Mail 3 Rec then 3 records and No Mail then 1 record. So for Mail Rec 1 to 3, only values not null will be returned and No Mail will only return records with null values for all Mail1 to Mail 3.

      Inv Number

      Mail1

      Mail 2

      Mail 3

      1

      6/15/2017

      6/16/2017

      6/17/2017

      2

      6/16/2017

      6/18/2017

       

      3

      6/17/2017

       

       

      4

       

      6/18/2017

       

      5

      6/19/2017

       

      6/18/2017

      6

      6/20/2017

       

       

      7

       

       

      6/21/2017

      8

      6/22/2017

       

       

      9

       

       

       

       

      Help, please. Thank you!