Calculated Dimension

[priyarane]

Hi Experts,

I have straight table and first dimension is calculated dimension as below.

=if(HNAH_3460S = 'Y','HNAH_3460S' ,if(HUSI_3401S = 'Y','HUSI_3401S',if(HBUS_3607S = 'Y','HBUS_3607S',

if(HTCD_37130 = 'Y','HTCD_37130',if(HBIO_1201S = 'Y','HBIO_1201S',if(HSI_32900 = 'Y','HSI_32900',if(HMUS_3285S = 'Y','HSI_32900','')))))))

And filters are like below:

HBUS_3607S

HBIO_1201S

HMUS_3285S

HNAH_3460S

HSI_32900

HTCD_37130

HUSI_3401S

for each filter has Y or N values.

so my requirement as below.

If I select HUSI_3401S then in the dimension it should display 'HUSI_3401S' only but it displaying 'HNAH_3460S' eve if I select any other filters as Y then also it displaying 'HNAH_3460S'. is there any expression should write please suggest me on this.

PFA.

[priyarane]

Its working Jagan.

Is it possible to write this at script level.

[jagan]

Hi Priya,

It is not possible to write this in script, because this expression depends on the Current Selections.

Hope this helps you.

Regards,

Jagan.