Is there any way to get a count of total records in a PivotTable that meets my criteria below:
For example, say I have 5 entries for Rita on the account 1234, and 3 entries for Rita on the account 6789. So I want to set up a pivot table that shows me Rita's accounts with a count of only 2 - 1 for account 1234 and 1 for account 6789. So I want the account to show up only one time, which is working fine, but then if I include subtotals, I'm getting the totals for all the account records (8) instead of just having the system count each account once. I can't figure out how to do this. I keep getting a total count of 8, but that's not what I want. I have attached a screen shot, too, so you can see another example. So in the example, I want to count the number of records under each Approver's Name. There are multiple records for each Approver if I were to click on the plus sign by their name. The records may appear multiple times in the underlying data source, but I only want it to count one of those. Hope this is making sense.