9 Replies Latest reply on Oct 4, 2016 2:05 PM by ammanuel.selameab.0

    Filtering based on a group, but displaying members of the group


      I am trying to create a filter such that I can slect a group (using a combo of sets and a calculated field, I'd imagine), but.....when I select the group within the Quick Filter, I want it to display members of the group, and not the group aggregated.


      As an example, in the attached. I would like to create a group called ABC (which is customers A, B, and C grouped together), and have that show up as an option within the Quick Filter. But....when I select ABC, I want it to display customers A, B, and C individually (and their individual spend), and not the sum of A+B+C.


      Could use some help! Thanks in advance!


      Update - workbook attached now.