1 Reply Latest reply on Mar 13, 2013 12:04 PM by Tracy Rodgers

    Summary with multiple filters

    doh.doh

      Hello all,

       

      I'm trying to create a summary tab displaying the number of records and number of distinct IDs, but each line of this summary applies a different filter

       

      Sample of my data:

       

      Transaction_ID     Line_ID            Amount     Date          Filter1     Filter2     Filter3

      1001                    1                    100            1/1/2013     1            0            1

      1001                    2                    200            1/1/2013     1            0            1

      1002                    1                    400            2/1/2013     0            0            1

      1002                    2                    500            2/1/2013     0            0            1

      1003                    1                    700            3/1/2013     1            1            0

      1003                    1                    800            3/1/2013     1            1            0

       

      I'm trying to achieve a summary which looks like this:

       

      Criteria     Number of records     Number of unique records     Total Amount

      Filter1      4                              2                                        300

      Filter2      2                              1                                        1500

      Filter3      4                              2                                        900

       

       

      Will it be possible to create a summary table like that? As of now, I can only figure out how to create the summary of one filter in one sheet (please refer to the attached workbook!). How can I achieve the desired result without creating multiple sheets?

       

      Thanks!