+ Reply to Thread
Results 1 to 3 of 3

Problem in Making Pivot table

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    pune
    MS-Off Ver
    Excel 2007
    Posts
    57

    Problem in Making Pivot table

    Hi All,

    Could you help me with the pivot table . I have attached the sample file which conatin 15 column 1st column is appliction name and rest column contains the name of the person whose usethat application and they marked yes and no when they use that application in the spcific row


    I want to create the pivot table in which row column application name should come and with that i want the count of number of yes and NO

    please do the need full
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Problem in Making Pivot table

    hi sameeru, the total of "Yes" & "No" in a row? i had to create 2 extra columns in your data for the sum of "Yes" & "No". see if this is what u need
    Attached Files Attached Files

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    05-07-2012
    Location
    pune
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: Problem in Making Pivot table

    It seems ok Thanks a lot..

+ 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