To display multiple selected values in dimension

[#1]

Hi all,

I have a multi-box which has job-role as a field.This job role includes data like: teller, manager etc.,.

I have a pivot table with branch name,job role as dimension.

The requirement is if i select >1 value in job role box, that values have to be displayed in dimension of pivot table.

In edited dimension i used like:=if(match([Job Category],$(vRole_Selection)),[Job Category])

where (vRole_Selection)=GetFieldSelections(Job Category)

but i am not getting desired results.

[#2]

is there any way?

[PrashantSangle]

Hi,

Not clearly understood,

but i think you dont required calcualted dimension.

just add [Job Category] as dimension.

then go to chart property->General-> Calculated Condition->write below condition

if(getselectedcount([Job Category])>1,1,0)

Regards

[#4]

dreamer4‌

Hi,

what i mean is all the selections that  i made in drop down multi-box; they should get reflected(must come) in the chart under the corresponding branches.

say suppose; there are 2 branches "bradlee", "northsouthcarolina".

under "bradlee" branch say there are employees with "teller","teller coordinator" as  job roles/emp_roles.

and under "northsouthcarolina" branch say there are employees with only  "teller" as  job roles/emp_roles.

so if i select "teller" in multibox; under bradlee and northsouthcarolina branches it should show only "teller" under the job roles/emp_roles column which is in the chart.

if i select "teller","teller coordinator" in multibox; under bradlee it should show "teller","teller coordinator".

and under northsouthcarolina it should show only "teller".

PFA

[#5]

Hey can any one Answer this?