+ Reply to Thread
Results 1 to 3 of 3

PivotTable: How to show two values; one with column breakdown, the other without?

  1. #1
    Registered User
    Join Date
    06-21-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question PivotTable: How to show two values; one with column breakdown, the other without?

    Hi all,

    I am trying to do this with PivotTables

    Untitled.png

    Whenever I place the Bookings breakdown in the Column field, pivot table with also try to breakdown my Appointments. Is there anyway around this?

    Many thanks in advanced

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: PivotTable: How to show two values; one with column breakdown, the other without?

    In 2003, you may only hide columns for Appointments which you do not wish to see.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    06-21-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: PivotTable: How to show two values; one with column breakdown, the other without?

    Hi Izandol,

    Thanks for the suggestion. It would be disorientating for users to do this but this might be the only way. Anyone else have any other suggestions?

+ 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. Breakdown Cells with values seperated by ; to row based on combobox selection
    By dooz1990 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2013, 04:44 PM
  2. [SOLVED] Pivottable won't show new entries
    By CDEG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2013, 05:15 PM
  3. Show breakdown of a SUM formula
    By mvb83 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2013, 10:08 AM
  4. Need some help on a function to show hourly breakdown instead of daily/weekly
    By Daniel Dawson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2012, 02:32 PM
  5. Excel column breakdown
    By Maui_High in forum Excel General
    Replies: 2
    Last Post: 06-26-2007, 05:32 PM

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