Solved

PIVOT TABLES

Posted on 2011-03-24
5
380 Views
Last Modified: 2012-05-11
Hi,

I failed to create a Pivot Table from "All"  worksheet.

Please help.

Thanks

Kathryn
Test-5.xls
0
Comment
Question by:KathrynT
  • 3
5 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 250 total points
ID: 35212098
unmerge cell M4:M5 and add a title in cell M5.
Add a title in cell A5 if you want that column in your pivot.
Run the pivot with range starting in row5

Thomas
0
 

Author Comment

by:KathrynT
ID: 35212370
Thanks, Thomas.

I'm going to try out.

Kathryn
0
 

Assisted Solution

by:jayakum108
jayakum108 earned 250 total points
ID: 35216763
(1) You've got Columns L and M hidden.  I unhid them.
(2) M4 and M5 were merged.  I unmerged them.  This way, you can select just row 5 as the title column.  Otherwise you will select Row 4 as title row, which has not titles.
(3) This still did not work for me.  So I copied the entire data and pasted values into a new workbook.

After that, it worked well for me.

Best,
Jay
0
 

Author Comment

by:KathrynT
ID: 35471012
Thanks.
0
 

Author Comment

by:KathrynT
ID: 35471017
I like to close today.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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,…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

910 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

21 Experts available now in Live!

Get 1:1 Help Now