 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
11-02-2005, 06:17 PM
|
|||
|
|||
|
Count unique values - Pivot Table
Hi,
I've some problems to count unique items (Invoice #) in a pivot table. There is the default solution "Add-a-new-calculated-column" as mentioned on http://contextures.com/xlPivot07.html#Unique, but in my case, it doesn't works. My problem is, that these values aren't in a Excel worksheet; it's a external data source - a SQL-Select via DAO/ADO. Because of that, I don't have the possibility to add a new column. Another reason is, that the pivot table should always be dynamic: Group over this field, group over another field - and always show the number of unique invoices, not the sum of data rows (please take a look at the attached Excel sheet). Thx, Thomas (or is there an easy way to write an User Definied Function and access to the data rows in each pivot table group?) 
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
