Hiding rows in pivot if one value is zero

[#1]

Dear All,

I have attached the excel raw data and qvw file.

I have put a pivot table in QV, however i need to hide the complete row if one of the value in the pivot is 0.

Is it possible using expression in pivot table.?

The final result should look like th below. Here it is hiding 3 rows where some value are 0 and displaying only two rows.

H2	A	B	C	D	E	Grand Total
ABC	-100	-150	-50	-45	-75	-420
CDE	-300	-55	-30	-55	-400	-840

Regards

Nassar

[sujeetsingh]

One thing you can try is supress null...

but i want to know that which are dimensions??

means ...

[#3]

Thanks for your reply,

I tried suppressing null but it only hides where all the values are null or zero. Here you have the raw data.

H1	H2	H3
A	XYZ	-200
A	ABC	-100
A	CDE	-300
B	ABC	-150
C	IJK	-60
D	ABC	-45
D	CDE	-55
E	OPQ
E	ABC	-75
C	CDE	-30
C	ABC	-50
B	CDE	-55
B	IJK	-105
E	CDE	-400

and the pivot looks like this in excel. i want to display only first two rows as i have values for all.,i.e for A,B,C,D,E.

Sum of H3	H1
H2	A	B	C	D	E	Grand Total
ABC	-100	-150	-50	-45	-75	-420
CDE	-300	-55	-30	-55	-400	-840
IJK	-105	-60	-165
OPQ
XYZ	-200	-200
Grand Total	-600	-310	-140	-100	-475	-1625

[sujeetsingh]

So now we have to use H1 and H2 as dimension and sun(h3) as expression ..

I tried like this but i didnt get any zero value

[sivarajs · Accepted solution]

This is one way to do.Check the file

[#6]

Thanks Sivaraj,

It worked and is awesome.

[#7]

hello,

can you please help me for this

I want to hide the expression column in which I am calculating the value but that value I am using in next expression

and my condition is that i want to hide that calculated 1st column and resulted 2nd column should be visible

[#8]

Hi Shreeaaradhya,

You can hide column.

Chart properties->presentation->Hide Column

--Prabhu Ch