Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Subtotaling Index Pivot Tables

    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...
    Posted to Pivot Tables (Forum) by That Excel Guy on Tue, Jul 22 2008
  • Re: Distinct Count in pivot table

    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...
    Posted to Pivot Tables (Forum) by Nick Hodge on Sat, Jun 28 2008
Page 1 of 1 (2 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.