+ Reply to Thread
Results 1 to 5 of 5

Pivot Table based on specific values from multiple columns

Hybrid View

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    North Babylon, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Pivot Table based on specific values from multiple columns

    Doing that would filter the "Humans" row as well. I need to perform that exact filter, but ONLY on the "Confirmed" row.

    The data I am displaying is accurate, but the problem is when I double-click on a number, it shows all the records because I am using the "Sum Of" value which just adds all the 1s and 0s. Ideally, the columns would have "Yes"/"No" values and I would want to do a Count Of "Yes" values so drilling down would present a view filtered by the selected Region AND only the "Yes" rows
    Last edited by Jaypoc; 09-21-2012 at 09:25 AM.

  2. #2
    Registered User
    Join Date
    11-14-2012
    Location
    Arizona
    MS-Off Ver
    2010
    Posts
    1

    Re: Pivot Table based on specific values from multiple columns

    Hi,

    Did you ever find a resolution to this issue? I have the exact same problem. Built a great report but users need to drill down. Only after building the report did I find out that I can't drill down to the Sum value. For example, for confirmed/north I would want 23 but I get 42.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1