How use only function

[wossenhh]

Hi,

I have a pivot chart that shows the following table:

Employee	Client	YTD Hours
John	A	10
Merry	B	15
Jim	C	25
Bob	D	35
Ron	E	55

How can I display on a pivot chart only client B, D and E with their results?

Thanks,

Wossen

[mikecrengland]

You can put it in your set analysis...

Sum(({<Client={'B','D','E'}>} [YTD Hours])

mike

www.fortunecookiebi.com

[Clever_Anjos]

You can use a calculated dimension

if(Match(Client,'B','D','E'),Client)

and check "Supress when value is null"

[#4]

The most optimized I can think of is create a flag on the back-end and use that flag on the front-end instead of trying to use expressions on the front-end.

Its just a general suggestion to try to move as much as possible to the back-end where it will be pre-calculated and wont impact performance.

Hope attached is of some help.

Thanks

AJ

[Anonymous]

Clever,

I think in calculated dimension you have to use aggr():

aggr(if(Match(Client,'B','D','E'),Client), Client)

[gouthamkk]

Hi,

Try this, for client dimension. select add calculated dimension and place below condition

if (client='B' or 'D' or 'E', Client , null())

and then in the same tab "Suppress when value is null".

Note : Make sure you select the dimension above and check the below once.

[wossenhh]

Thanks AJ for your advise  and for the attachment. It works well and you are right it is better to work from script!

Best,

Wossen

[Clever_Anjos]

Not strictly necessary, PFA