Merging dimensions at Dashboard level

[#1]

HI,

How to merge two dimensions into one at dashboard level.

Lets say i have field

Enquiry

ASD

BSD

CSD

and another field

Lead

QWE

WER

So the Final Field should result should be

Customer

ASD

BSD

CSD

QWE

WER

Regards,

Keerthi KS

[sunny_talwar]

May be this as your calculated dimension:

=ValueList($(=Chr(39) & Concat(DISTINCT Enquiry, Chr(39) &',' & Chr(39)) & Chr(39) & ',' & Chr(39) & Concat(DISTINCT Lead, Chr(39) & ',' & Chr(39)) & Chr(39)))

[#3]

Hi Sunny,

I cant select from the list if i use this way. That should be like a filter.

Currently i have two dimensions used for a table.

I need single filter for both dimensions.

Regards,

Keerthi KS

[#4]

The better way is concatenate in the script the two dimensions...

[#5]

Hi Marcos,

Any other way without concatenating ??

Regards,

Keerthi KS

[sunny_talwar]

To be able to make selections, I think you will have to do this in the script by concatenating them together.

[#7]

Sorry, I just know this way or as Sunny said..