3 Replies Latest reply on Oct 10, 2018 5:45 PM by Alex Martino

    How to filter out categories that don't have values every day

    Alex Martino

      Hello. I have this filter for the last 30 days.

       

      [Date]>Dateadd('day',-30,{Max([Date])})

       

      How can I filter out categories that don't have data EVERY DAY of this period. I have some product that are new and only have sales for the last 5 days and I don't them to show up.