Suppress 0 rows for specific rows

[agni_gold]

Hi Friends,

I have one situation, I have one pivot table and in which one column is from inline table and wrote expression for each measure, now I only want to suppress those rows which are fully zero for all measures like below screen shot, how can I achieve this

[effinty2112]

Hi Agnivesh,

If Suppress Zero Values is checked in the Presentation tab that should hide dimension values where both measures are zero. If one measure is non-zero the dimension values will still be shown.

Country	State	Variety
A	A1	Green	Sum(Amount)	19
			Sum(Value)	2
		Orange	Sum(Amount)	2
			Sum(Value)	0
		Red	Sum(Amount)	1
			Sum(Value)	0
		Yellow	Sum(Amount)	4
			Sum(Value)	24
	A2	Green	Sum(Amount)	25
			Sum(Value)	14
		Orange	Sum(Amount)	5
			Sum(Value)	22
B	B1	Green	Sum(Amount)	22
			Sum(Value)	24
		Orange	Sum(Amount)	21
			Sum(Value)	0
	B2	Green	Sum(Amount)	25
			Sum(Value)	0
		Orange	Sum(Amount)	24
			Sum(Value)	11
		Yellow	Sum(Amount)	26
			Sum(Value)	0

Regards

Andrew

[agni_gold]

thanks,

but when we doing pivoting over measure field , then this is not happening .

[Anil_Babu_Samineni]

May be this?

=Pick(Match(Measure,'One','Two'),

If(sum(Value)>0,Aggr(sum(Value),Country, State,Variety, Measure, Year)),

If(sum(Amount)>0,Aggr(sum(Amount),Country, State, Variety,Measure, Year))

)

[agni_gold]

i tried this option also but not working