Pivot Table help

Posted on 2011-10-26
Last Modified: 2012-05-12
I have a column with a yes or no value. Is there way to have a pivot table display the count on yes and the count on no? Seems simple enough but I'm having trouble figuring out how. When I do one it shows the no value and tells me there is 1103 on the count but that's not true. There are 1103 total of the no and yes responses.
Question by:SDTSS
    LVL 24

    Assisted Solution

    You need to put the column in the row field and in the data field.

    Author Comment

    In the row and the value? If so I do. I'm attaching a couple of screen shots.

    The column I'm basing the pivot table on

    The pivot table
    LVL 24

    Expert Comment

    On the row field is it possible you have deselected 'Yes', because what you've done looks ok to me?

    Post a workbook?
    LVL 27

    Accepted Solution

    StephenJR's solution should work.

    I don't think "Yes" was deselected, otherwise it would show a filter icon in the drop arrow button next to "Row Labels".

    Try doing a PivotTable refresh and see if that works.

    Author Comment

    It was the refresh! That's how I had it from the beginning but yes never showed up until I said refresh all under my pivot table options. Thank you!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now