3 Replies Latest reply on Feb 12, 2017 11:56 AM by Jessica Reason

    Using the Filter Shelf (for a measure) not at the ROW level

    Jessica Reason

      Hi...

       

      I'm trying to add a simple filter to my data, but I don't want to add it at the ROW level, I want it to filter at the Quarter level.

       

      I have daily sales data for a variety of IDs.  I am trying to get a distinct count of IDs, by quarter, using the measure (sales) as a filter by Quarter (not daily at the row level).  This seems possible, am I overthinking this?

       

      See attached.