4 Replies Latest reply: Aug 14, 2012 8:58 AM by Rick Huebner RSS

    Help with Set Analysis on Pivot Table

      I have the following data (column names in first row)

       

      Employee Name, Timesheet Date, Charge Code, Account Name, Amount

      Joe Smith, 11/10/2011, 0010, Labor - Direct, 1000

      Joe Smith, 11/10/2011, 0010, Labor - Haz, 400

      Joe Smith, 11/10/2011, 0010, Labor - Post, 400

      Joe Smith, 11/10/2011, 0015, Labor - Direct, 2000

      Joe Smith, 11/17/2011, 0010, Labor - Direct, 2500

      Joe Smith, 11/3/2011, 0010, Labor - Direct, 1200

      Joe Smith, 11/3/2011, 0010, Labor - Haz, 400

      Joe Smith, 11/3/2011, 0010, Labor - Post, 400

      Steve Jones, 11/10/2011, 0015, Labor - Direct, 1700

      Steve Jones, 11/03/2011, 0015, Labor - Direct, 2000

       

       

      I want to show in a table whenever an employee charges more than one Account Name on a given Timesheet Date. I've been working on this and can't seem to get the combination of COUNT and set analysis correct to show this. Records where there is only one account name for a given timesheet date should not be shown.

       

      I currently have this in a pivot table, but would be open to a Straight Table or even Table Box if that would help.

       

      Thanks