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 |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com