Calculated Dimension with Clear Selection Box

[krishnacbe]

Hi

I have used a calculated dimension in a straight table.

Dimension:

=if(ExceptionsTeamIntervention='-1',if(Code='no_suitable_appointment' or Code='contractor_not_found' or Code='appointment_not_found' or Code='manual_deployment_required',ExceptionType)) 

If I select some value in Exception Type, Current selection box is displayed as below

But In current selection box I need to show only Exception type not Code or ExceptionsTeamIntervention details.

Please anyone help me to fix this.

Thanks in advance.

Regards

Krishna

[#2]

hi,

shift the expression in the backend.

[krishnacbe]

Hi

Thanks for your fast reply.

I have 3 tabs. In different tabs Code condition varies. So I can't apply the condition in backend. please give some other solution.

Regards

Krishna

[chematos]

Have you tried to uncheck some option of Current Selection Box? May be there is an option that only shows selected dimensions and nothing else.