hide part tags from dimension

[Anonymous]

Hi,

I have chart. I want to show only A,B,D tags with them %.

If I use condition IF(Var1<>C and Var1<>E,Var1) in dimension, it shows % based on A,B,D.

If I use condition IF(Var1<>C and Var1<>E,count(Var1)) in expression, it shows % based on A,B,D. (the same as in dimension)

Thanks,

[whiteline]

Assume: dim1 = {A, B, C, D, E}, dim2 = {aa, bb, cc} and Value field for counting.

Create bar chart with dimenions dim1, dim2 and expression:

=Count({<dim1={A,B,C}>} value)/Count(total<dim2> Value)

[Anonymous]

Hi Whiteline,

My dim2 is not 1 variable.

I calculate so

My dimension: Var 1.

Expression:

1. Count({<[Var 3]=, [Var4]=>} [Value])  ------aa

2. Count({<[Var 3]=>} [Value])               ------bb

3. Count([Value])                                  -----cc

All 3 expression I checked Relative.

Regards,

[whiteline · Accepted solution]

Ok, I thought there are two dims.

1) Uncheck realtive.

3) Use condition in set analysis instead (see below).

2) Calculate relative manually like this: =Count({<[Var 1]={A,B,C}>} [Value])/Count(total [Value]) etc.

[Anonymous]

Hello my fried.

Thanks, you're right. It works.