+ Reply to Thread
Results 1 to 3 of 3

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 Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    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
    Please familiarise yourself with the rules before posting. You can find them here.

  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

+ 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