If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Manipulating Pivot Table Data Fields
Hi all,
Have a question regarding the Data Field in pivot tables. I have a number of rows that have repeating values. What I want in the Data Field (Sum) is a count of DISTINCT values in the column. ie: FR065817 \ FR065817 |---- counted as one FR065817 / FR066154 \___ counted as one FR066154 / FR066158 ----- counted as one FR066159 \___ counted as one FR066159 / However I need all the data in the table as I'm using other columns for different fields in the pivot table. Is there a way to do this? If I have to split the table somehow, I'm willing to do it, but I'd need some help with how do go about doing that. Any help is appreciated. Thanks, Jay |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change Data In Pivot Table | John Calder | New Users | 1 | July 7th, 2005 10:41 PM |
Help with relationship plase | Rock | General Discussion | 5 | July 4th, 2005 03:54 AM |
Help with relationship plase | Rock | Database Design | 5 | July 4th, 2005 03:54 AM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Update - If statement | Dan @BCBS | Running & Setting Up Queries | 13 | December 14th, 2004 06:02 PM |