Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Pivot Table excel 2010

Posted on 2012-08-13
Medium Priority
Last Modified: 2012-08-13
I want to create a pivot table in excel 2010.

Currently i have the pivot table, i have a reference number, and then 4 columns of data.

I want to be able to click the + beside my reference number, and then see all the fields from that reference number, and then when the + isnt clicked i want to see the subtotals.

Is this possible? At the moment all i can see is the subtotals.
Question by:CaptainGiblets
  • 2
LVL 50
ID: 38286876

the idea of the pivot table is that it summarises data with the same properties. If you don't want to do that, then maybe grouping on the sorted source table is more appropriate.

See attached.

Can you post a small data sample with dummy data that reflects the structure of your source table?

cheers, teylyn

Author Comment

ID: 38286907
Here is a sample. I know i can do this using subtotals, but it takes around 8 hours on my laptop to process it, and any time i change anything it takes ages to update, which is why i am trying it on a pivot table.

I can get the pivot table set up to show the subtotals, and if i double click 1 of them it will show me the drill down values in a seperate sheet, but i really need them in the same sheet.
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 38287092
That must be one heck of a big workbook.

Tom Urtis wrote some code a few years ago in this thread

I've plugged the code into your sample file.

When you double click a cell in the pivot table, the data drill-down will appear underneath the pivot table. Double click a cell in this drill down table to make it disappear again.

That's the best I can think of. Pivot tables are not designed to drill down to the item level in side the pivot.

cheers,  teylyn

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

564 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