+ Reply to Thread
Results 1 to 3 of 3

Thread: Tivot-table

  1. #1
    Registered User
    Join Date
    06-13-2007
    Location
    Västervik, Sweden
    Posts
    42

    Exclamation Tivot-table

    New problem needs a solution.

    I got one colum containing facts about certain Dimensions and lengths like for instence: Dim 120 * 120...AND sometimes i get the dimension 0 like: Dim 0 * 120.
    I would like to know if there is a way to make the tivot-table not include the one having the Dim 0 ??

    Thanks in advance

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003 & 2007
    Posts
    3,661

    Smile

    Good morning chojje

    On your pivot table, the title row should have some little dropdown buttons. Clicking on any of these will show all the fields under that particular heading. You can just untick any of these boxes to suppress that particular row.

    If that is not the case can you post any example to have a look at? It's quite hard to visualise someone's description of a pivot table. There's usually that many fields and stuff...

    HTH

    DominicB
    Now available : Ultimate Add-In 2007
    Integrates directly into the Office Excel Ribbon


    Download Ultimate Add-In v1.52 from www.dom-and-lis.co.uk
    90+ Utilities, 200+ Sub utilities last updated 25th April 2008
    Free!!

  3. #3
    Registered User
    Join Date
    06-13-2007
    Location
    Västervik, Sweden
    Posts
    42

    Wink

    Quote Originally Posted by dominicb
    Good morning chojje

    On your pivot table, the title row should have some little dropdown buttons. Clicking on any of these will show all the fields under that particular heading. You can just untick any of these boxes to suppress that particular row.

    If that is not the case can you post any example to have a look at? It's quite hard to visualise someone's description of a pivot table. There's usually that many fields and stuff...

    HTH

    DominicB
    I just managed to pull it through Thanks anyway..again

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.2.0