Two fields in one dimension

[#1]

Is there any code to combine two fields in one dimension? Example like object_operator and stuffs_operator displaying in one dimension.

FYI: I'm not refering to cyclic group

[#2]

Depends on what kind of chart you are using. For instance, if you are using a pivot, you can add calculated dimension and combine the two fields

[#3]

Pls check..

object_operator & stuffs_operator As [object_operator stuffs_operator],

Regards-Bika

[narender123]

Hi ,

You can make it as composite kay in script.

Like:

load

object_operator,

stuffs_operator,

object_operator & '-' &stuffs_operator as Key

from Table abc;

Thanks,

Narender

[er_mohit]

Try this in dimension

object_operator & '  ' & stuffs_operator

hope it helps

[#6]

Yes, i'm using pivot table. How to combine them?

[#7]

add a calculated field as dimension wheren concatenate them using & operator. Checkout the sheet 1 in the attached Sales file.