Making a pivot table with lots of data
Hello,
I am having issues trying to make a pivot table. I have a lot of data that I am trying to covert to a pivot table but when I try add it, it adds up a sum of total answers! I have tried doing it one question at a time but when I try adding another question into the table it sends my answers all over the place.
I would be greatful if someone could try help me solve this issue
Megan
Could you upload a sample of your data and an explanation of what questions you would like the pivot table to answer?
There needs to only be enough desensitized (if applicable) data that we can see what the problem is.
To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks