Pivot Table Hide Row with no data?

[Bebert]

Hi there!
I face a problem with my Pivot Table. I would like to hide automatically the rows where there is no data in the TOTAL column (the last one). Is it possible?
Thanks in advance for your help!
Bebert

 

[Mark W.]

What do you mean by "no data"?

 

[clare_voiant]

you may find that in the drop down arrow for that column that there is a checkbox for "blank", uncheck this box.....

 

[Bebert]

Thanks for your replies, let me try to explain better:

The original table from where I have created the Pivot Table looks like this:

Cat Rplan Brate DLXK DLXQ DLXT
VOLA HWEB1 330
SPEC HWEB2 280 300
SPEC HWEB3 420 420 420 420
HTL3 HWEB3 250
VOLA HWEB4 400 400 400 400
VOLA HWEB4 230 250
HWEB HWEB5 200
HWEB HWEB6 170 200
HWEB HWEB7 140

On my Pivot Table, I would like to hide the lines where there is no figure in the Total column. Cat, RPlan and Data columns can be filtered, but not the Total column...

Cat RPlan Data Total
JRST 445
CORN
PRES 2005
KING
VOLA LFAW DLXK 165
DLXQ 165
DLXT 165

I'm not really sure that this is clear, but in case somebody understands...
Thank you!
Bebert

 

[Mark W.]

You need to reorganize your data (into 1st Normal Form -- 1NF) as shown below...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
12
13	Cat	Rplan	Brate	Category	Value			SumofValue
14	SPEC	HWEB2	280	DLXQ	300			Cat	Rplan	Category	Total
15	SPEC	HWEB3	420	DLXK	420			HWEB	HWEB6	DLXK	200
16	SPEC	HWEB3	420	DLXQ	420			SPEC	HWEB2	DLXQ	300
17	SPEC	HWEB3	420	DLXT	420				HWEB3	DLXK	420
18	VOLA	HWEB4	400	DLXK	400					DLXQ	420
19	VOLA	HWEB4	400	DLXQ	400					DLXT	420
20	VOLA	HWEB4	400	DLXT	400			VOLA	HWEB4	DLXK	400
21	VOLA	HWEB4	230	DLXT	250					DLXQ	400
22	HWEB	HWEB6	170	DLXK	200					DLXT	650
23
Sheet1

This message was edited by Mark W. on 2002-10-29 12:33

 

[Bebert]

Thank you Mark!
I see now what would be the solution, but I won't be able to use it since my 1NF has 20 different categories (DLXQ,DLXK,...) and more than 5000 lines for the time being. If I understand you properly, I would have to use different lines for each category and would then have 100'000 rows (less the ones with no value).
Thank you anyway for taking the time!

 

[Mark W.]

On 2002-10-30 03:22, Bebert wrote:
...If I understand you properly, I would have to use different lines for each category and would then have 100'000 rows (less the ones with no value)...

Perhaps it's time to think about moving your data to an external (from Excel) database application.