-
Hi Everyone - I have a stumper that several other boards did not have an answwer for, and I hope that someone can help. I have to run several pivots to fill a crystal xcelsius excel input model - two of them count partner company names and user IDs by region and country via the index function. What I...
-
Pam COUNT(DISTINCT(...)) is not currently possible in a pivottable field you will need to do that in the database. If your data is pivotted from a flat table already in Excel though, there is some instruction on setting up this column on Debra Dalgleish's site http://www.contextures.com/xlPivot07...