+ Reply to Thread
Results 1 to 2 of 2

Pivot Table : getting count of multiple value by filter

  1. #1
    Registered User
    Join Date
    04-30-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Pivot Table : getting count of multiple value by filter

    excelscreenie.jpg

    What I'm trying to do is pivot this data and then get the count of No in the Rows filtered by the Headers 1.1, 1.2, 1.3, etc.

    Like

    1.1 23 No's
    1.2 20 No's

    Then my report filter would be the Group number.

    Thanks.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pivot Table : getting count of multiple value by filter

    Maybe you are able to re-arange your data in a table.

    Probably it can be done with a macro.

    After that is easier to use a pivot table.

    If you add a file (without confidentional information) I will take a look at it.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Top 5 Pivot table filter by inner row field count
    By theThirdMan in forum Excel General
    Replies: 1
    Last Post: 12-12-2012, 02:38 AM
  2. Using multiple filter for Pivot table
    By shan.hunk in forum Excel General
    Replies: 0
    Last Post: 08-01-2012, 05:56 PM
  3. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  4. Pivot table filter data field to show items with count more than n
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2010, 07:36 PM
  5. Capture Pivot table filter count
    By whornak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2005, 08:10 PM

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