+ Reply to Thread
Results 1 to 7 of 7

depending data in pivot table

  1. #1
    Registered User
    Join Date
    09-29-2008
    Location
    Netherlands
    Posts
    5

    depending data in pivot table

    I am looking for a way to show dependent data in a pivot table.

    For instance, when I select a region, I would like to see only the related items to that region, not all possible items.



    Region number

    North 1

    North 2

    North 3

    South 4

    South 5

    South 6



    When creating a pivot table, I put these values in the page section.

    Selecting a region and than the number, shows unfortunately all numbers and not just 1,2 and 3.

    Iím thinking of creating a filter, copy the found data en than make a pivot table. The problem than is that when an other region is selected, I should update the filter and than update the pivot table, so that isnít really a solution.


    Is there a solution for the problem as described above?


    Greetings



    ncb

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394
    is this what you want?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-11-2008
    Location
    Hyderabad
    Posts
    54
    Hi Ncb,

    Your Query is Bit hard to understand !

    Here Pivot is a Tool which operates data into required format but it depends the way use the fields like - Page , data & section

    Probably you can drag the Page section to the field section so that it can point out the format u require.

    Best regards
    Surya

  4. #4
    Registered User
    Join Date
    09-29-2008
    Location
    Netherlands
    Posts
    5
    Hallo Mallycat,

    That's almost what I want.
    Thank you for answering.

    I think I didn’t make myself quite clear.

    Of course in the pivot table itself you can only see the related items.

    But in the page field when clicking the small arrow, I would like to see there only the related items to for instance the region North.

    So when in the page field I select a region, in the other page field I would like I could only choose the related items.

    Referring to Access, it's a result of a query using in an other query.

    Greetings,
    ncb

  5. #5
    Registered User
    Join Date
    09-29-2008
    Location
    Netherlands
    Posts
    5
    Hallo Surya,

    Thank you for answering.

    I think I didn’t make myself quite clear.

    Of course in the pivot table itself you can only see the related items.

    But in the page field when clicking the small arrow, I would like to see there only the related items to for instance the region North.

    So when in the page field I select a region, in the other page field I would like I could only choose the related items.

    Referring to Access, it's a result of a query using in an other query.

    Greetings,
    ncb

  6. #6
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394
    OK, try this. Move the region from the page location into the main table. Then click on the drop down arrow against the region heading, and deselect one of the items and click OK. Then drag the region headind back to the page location. Any items you have selected/deselected will stay in that state.

  7. #7
    Registered User
    Join Date
    09-29-2008
    Location
    Netherlands
    Posts
    5
    Thanks.

    It works for one region.
    But when selecting an other region, the items belonging to that region don't come up.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. pivot table counting blank cells in data table
    By nicko54 in forum Excel General
    Replies: 4
    Last Post: 09-23-2008, 11:26 AM
  2. Setup data for Pivot Table
    By Paul7 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2008, 11:46 AM
  3. Data not displaying in pivot table
    By Lacklustre in forum Excel General
    Replies: 1
    Last Post: 03-11-2008, 09:54 PM
  4. Return pivot table range...not the data table, the PIVOT TABLE!
    By Air_Cooled_Nut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 01:07 PM
  5. Extracting Data from a Pivot Table and comparing
    By mwburne@yahoo.c in forum Excel General
    Replies: 1
    Last Post: 10-19-2007, 08:31 AM

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