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,

[Anonymous]

I tried on your file. If I remove expression from text color and font, I got the same result.

My table is corrupt. Expressions in color and font compute all variants. (even if they not shown in table)

[rwunderlich]

It looks like your Text and Background color expressions bring in the extra dim values, because you are not using the set modifier in those expressions. I believe  you can simply the entire process by using a calculated dimension of:

=if(MixMatch([Browser],'Chrome','Firefox','IE','Safari'), [Browser])

and then your expression becomes simply:

count(Browser) / count(TOTAL <MYear> [Browser])

Seems to work for me. See attached.

-Rob

http://robwunderlich.com

[Anonymous]

Thanks Rob.

You do miracles.

[Anonymous]

Hi Rob,

I tried with other table. It didn't work, because it uses 100% just selected tags, not for all tags.

If(mixmatch(Field, 'A', 'B', 'C'),Field)

For example

A=55%    A=45%

B=25%    B=20%

C=20%    C=15%

100%       D=20%

                  100%

Thanks,