It is possible to use distinct count for the aggregation in the values section of a pivot table? For example - Need to get a distinct count of employees - employees listed on multiple projects.
Thanks.
It is possible to use distinct count for the aggregation in the values section of a pivot table? For example - Need to get a distinct count of employees - employees listed on multiple projects.
Thanks.
In truth it is generally easier to add a column @ source, the new column being a calculation to apportion 1 in relation to the count of duplicity, such that the new field can be summed in the PT with result always being distinct.
It would be easier to provide an example if you could post a sample file that reflects your setup - obviously dummy names etc for confidentiality.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks