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
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!!
I just managed to pull it throughOriginally Posted by dominicb
Thanks anyway..again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks