Pivot Table excel 2010

Posted on 2012-08-13
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
    LVL 50

    Expert Comment


    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
    LVL 6

    Author Comment

    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

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Suggested Solutions

    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    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 will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    794 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

    18 Experts available now in Live!

    Get 1:1 Help Now