Hide extra row in pivot table

[Anonymous]

Hello,

I have field Browser with 8 tags.

I want show only IE, Chrome, Firefox, Safari.

I use my expression:

count({<[Browser]={'Chrome','Firefox','IE','Safari'}>}[Browser])/

count(TOTAL <MYear> [Browser])

It shows data only for my selections. How can I hide them?

I should use aggr function. Who can help me with idea?

Browser	MYear	Feb 2012	Mar 2012	Apr 2012	May 2012	Jun 2012	Jul 2012	Aug 2012	Sep 2012	Oct 2012	Nov 2012	Dec 2012	Jan 2013	Feb 2013
IE		59%	60%	63%	55%	61%	57%	56%	60%	58%	55%	59%	59%	53%
Chrome		17%	18%	15%	16%	14%	16%	17%	16%	18%	18%	20%	18%	22%
Firefox		18%	16%	16%	18%	18%	17%	19%	17%	17%	18%	14%	14%	17%
Safari		6%	6%	6%	10%	6%	9%	7%	7%	8%	8%	7%	8%	8%
AppleMAC-Safari		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
IEMobile		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Mozilla		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%
Opera		0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%	0%

Thanks,

[#2]

Hi,

Go to properties chart, sheet Presentation and uncheck Suppress Zero-values.

I hope will be helpfull.

Regards,

Ricardo

[Anonymous]

Hello Ricardo,

It didn't help

[#4]

Share your app.

[er_mohit]

count({$<[Browser]={'Chrome','Firefox','IE','Safari'}>}[Browser])/

count(TOTAL <MYear> [Browser])

or

count({<[Browser]={"$(='Chrome','Firefox','IE','Safari"}>}[Browser])/

count(TOTAL <MYear> [Browser])

[Anonymous]

Please see attached file.

[Anonymous]

I think only aggr function helps me.Please see attached file.

[#8]

Hi,

I built other table. Now it found. Check the attached.

Regards,

Ricardo

[Anonymous]

Thanks,

Everything was correct.

I'm stuck with text color and font expressions.

[#10]

Hi,

I don't know, why your table has problems with the zero-values. Probably the if cause in "Text Color" and "Text Format" arte the problem.

Regards,

Ricardo