How to Hide Dimension

[peter_rtf06]

Hi.

I have a pivot table like this....

Country	City	TOTAL	Jan	Feb	Mar	Apr
Panama	City1	0	0	0	0	0
	City2	10	1	3	4	2
Costa Rica	City1	0	0	0	0	0
	City2	0	0	0	0	0
Colombia	City1	7	1	0	2	4
	City2	0	0	0	0	0
Peru	City1	15	6	5	0	4
	City2	17	5	8	3	1

I need to eliminate the dimensions "City1" and "City2" only when both are zero(0) in the total column (Red colored rows). Only in that case because If one of Those dimension has a value diferent of 0, I need to show both (even the row with the 0 value)

Sorry for my bad English and thank you.....

[vgutkovsky]

In the Presentation tab, is "Suppress Zero Values" checked? If so, then the row should be suppressed when all expression values = 0.

Regards,