Pivot table automatically suppressing zero/null values

[vipingarg23]

Hi Team,

I have below pivot table

Dimension1	Dimension2	Expression1 (Total)	Expression2
Country	IND	100000	129
	AUS	0	0

In this pivot table if both expression value is 0/NULL then it is not showing the  whole row as below while I am not suppressing any zero/null values.

Dimension1	Dimension2	Expression1(Total)	Expression2
Country	IND	100000	129

Why is automatically suppressing the value. Is there any way to get the first one pivot table. as I don't want to suppress.

[Anil_Babu_Samineni]

Suppress When value is null ticked option is available in Presentation tab.

OR

Check in expression?

[vipingarg23]

I don't want to suppress any value. I am saying that pivot table is

automatically suppressing value if both expressions have zero/null values

as shown above. I don't want to suppress that.

On Tue, Aug 22, 2017 at 9:30 AM, Anil Babu Samineni <

[Anil_Babu_Samineni · Accepted solution]

That's what i am presenting here. Please check those options. i think those options are not checked. May be share image from presentation tab

[vipingarg23]

I have checked both checkbox suppress zero/null values. Both are unchecked.

On Tue, Aug 22, 2017 at 9:46 AM, Anil Babu Samineni <

[tresesco]

Could you post your sample qvw that shows the issue?

[Anil_Babu_Samineni]

Yes, I agree with Tresesco.

But, For validation can you try with Dimensions "Show all values"

[vipingarg23]

Thanks guys for your help. I found my mistake. There were if condition

applied in my expression. Now it is working fine.

On Tue, Aug 22, 2017 at 10:49 AM, Anil Babu Samineni <