1 Reply Latest reply on Apr 27, 2013 3:19 PM by Shawn Wallwork

    Filtering aggregations by multiple criteria

    Scott Royston

      Sorry if this has been asked before.  I feel like I've seen an answer to something similar, but I can't seem to find the right search terms to pull it up.

       

      If I have a set of data on customer sales, something like:

       

      Customer,  Product, Amount, Date, Time

      ----------------------------------------------------------------------------------

      C1, P1, 100, 2013/04/02, 09:40:00

      C1, P2, 100, 2013/04/02, 11:00:00

      C1, P3, 400, 2013/04/03, 14:00:00

      C2, P2, 200, 2013/04/02, 09:40:00

      C2, P1, 100, 2013/04/03, 15:30:00

      C2, P3, 100, 2013/04/03, 18:40:00

       

       

      I'd like to compare the aggregated 'Amount' between two arbitrary sets of customers (with potentially other slicers), but only including those products where the customer sets have the products in common on the same day.

       

      So, in the example above, if I were comparing C1 and C2, it would only include rows 2,3,4,6.

       

      I feel like I should be able to do this with a table calculation and a level of detail of day, but I can't seem to get it right.

       

      Thanks for any help.