Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2012
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table question


    Hi all,

    I am trying to make a pivot table on a data part of which look like this

    Unit Project Check-1 Check-2 Check-3
    U-1 Proj-1 Yes No Yes
    U-2 Proj-1 No No Yes
    U-1 Proj-1 No Yes No
    U-2 Proj-1 No Yes YEs

    There are lot of Checks in my data and the possible anwer to it is Yes/No
    Now what I want to do is i want to create a pivot table which will give me Unitwise, Projectwise count of Yes/No under respective check.
    Just to make easy to understand it should give me result something like

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Dear Paddydive:

    Welcome to the lounge.

    Pivot Tables are great for numeric or dates but are bad with strings.

    Before getting a Pivot Table, I think the use of the functions CountIF and SumIF could get the results you desire.

    See the attached workbook. This is just a sample. The formulas could be placed anywhere you want in a spreadsheet and if needed some type of Filter or Auto Filer could be used to create custom reports.

    Good Luck

    TD
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Apr 2012
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Duthiet,

    I have already done this with Sumproduct formula. Just wanted to know if there is any option in pivot table to do this. Bcoz the user who is going to use this sheet is not conferable with excel formulas.

    Thanks for your help.

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Dear Paddydive:

    Your orignal post failed to provide the desired results. In addition for each row in the data is it always Yes or No?

    For maximum assistance by the entire lounge it is usually best to provide an attachement with a small example of the clean data and a sample of what the desired report or results should be for the project. By clean data I mean is non-confidential information data that presents the various fields within the data.

    Regards,

    TD

  5. #5
    New Lounger
    Join Date
    Aug 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile Regarding Help in Pivot Table

    Dear Duthiet,
    I have a similar situation where i am try to create a Pivote Table where the response is give be employees is captured (Only Yes/No). I have divisions under division branches ( For each division 5 Branches) and then the employees response for 16 questions with yes or no. I want to calculate under each branch how many yes and no for all 16 questions. sample excel sheet attached for your referance



    Quote Originally Posted by duthiet View Post
    Dear Paddydive:

    Your orignal post failed to provide the desired results. In addition for each row in the data is it always Yes or No?

    For maximum assistance by the entire lounge it is usually best to provide an attachement with a small example of the clean data and a sample of what the desired report or results should be for the project. By clean data I mean is non-confidential information data that presents the various fields within the data.

    Regards,

    TD
    Attached Files Attached Files

  6. #6
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts

    Pivot Table Question

    Hopefully this is what you want. I have often used pivot tables to count yesses and noes or Trues and Falses.

    Regards,
    Maria
    Attached Files Attached Files
    Maria
    Simmo7
    Victoria, Australia

Posting Permissions

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