+ Reply to Thread
Results 1 to 3 of 3

Pivot table - show absent categories

  1. #1
    Registered User
    Join Date
    11-01-2006
    Location
    Nottingham, UK
    Posts
    8

    Pivot table - show absent categories

    I often have to add or compare similar pivot tables. This is incredibly difficult and time-consuming if categories of a variable disappear when there are no occurrences.

    Does anyone know how to keep categories in a table even if there are no instances?

    I have attached an example. I need to add the two pivots, but the second pivot needs to have categories A3, A4, A5 etc included (with zero values obviously) before the addition can be performed.

    Can anyone help?

    Thanks ... in anticipation
    Attached Images Attached Images
    Last edited by andrefrancis1; 11-07-2007 at 03:53 AM.

  2. #2
    Registered User
    Join Date
    11-06-2007
    Posts
    1

    email

    sorry not quite sure how to use this forum

    I m trying to set a macro that automaticly copys everything int the worksheet then emails it to a particular address everytime then deletes certain fields i can get it to delete copy but cant get it to automaticly email the content once button is pressed in the worksheet any ideas please help help !!!!!!!!



    Stuart Richards

  3. #3
    Registered User
    Join Date
    11-01-2006
    Location
    Nottingham, UK
    Posts
    8

    Thumbs up

    Quote Originally Posted by andrefrancis1
    I often have to add or compare similar pivot tables. This is incredibly difficult and time-consuming if categories of a variable disappear when there are no occurrences.

    Does anyone know how to keep categories in a table even if there are no instances?

    I have attached an example. I need to add the two pivots, but the second pivot needs to have categories A3, A4, A5 etc included (with zero values obviously) before the addition can be performed.

    Can anyone help?

    Thanks ... in anticipation
    OK ... I realize now that I am asking for the impossible . There is no way that Excel can know the categories that it hasn't counted ... because they do not exist (... duh ... !)

    I have now used a VLOOKUP function approach to achieve what I want ... but I won't bore you with the details.

    Andre
    Last edited by andrefrancis1; 11-07-2007 at 06:05 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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