Combine three fields into one filed

[NavinReddy]

Hello All,

I have a requirement to show three fields in one dropdown section.

1. Org Level1
2. Org Level2
3. Org Level3

Now I need to show these fields under one drop down

LOB

Org Level1

Org Level2

Org Level3

Please help me

Thanks in Advance

Niranjan Pawar

[jobsonkjoseph]

Hi Niranjan,

The question is not so clear, but for drop down you can use MultiBox object.

[NavinReddy]

Hi Jobson,

Thanks for your reply,

But I want to use this field in chats, in single field i need to show this drop down.

Thanks,

NP

[jobsonkjoseph]

ok.

if the data can be shared, i mean atleast dummy data, we can try to figure out.

[chrismarlow]

Niranjan,

If these form a hierarchy and you really need to be able to show all levels at the same time, ignoring the hierarchy relationship then I think you will have to do some scripting to come up with a 1 to many mapping for each of your Org LevelX to associate with your fact table.

If it is the searchable nature of the hierarchy that is more important you could use a search object with the three fields added & a drill down group on the chart (with the 3 fields) that would then show most appropriate level depending on selection.

As Jobson suggests a few more details needed to help further.

Regards,

Chris.

[Jesh19]

Please elaborate your question.

Are these 3 (Org Level1, Org Level2,Org Level3) different fields? or values under some field.

I think you can make use of multibox.

[NavinReddy]

these are all 3 different fields, want to make it one field as per my requirement

[chrismarlow]

Niranjan,

We got that, but need to understand more about the other fields before making further suggestions.

Regards,

Chris.

[NavinReddy]

Hi Chris,

Using 3 fields i have to create below straight table

LOB	Q1'2018	Q2'2018	Q3'2018
Org Level1	45	56	87
Org Level12	8	26	10
Org Level3	10	-4	-67

Thanks & Regards,

NP

[nasirsaikh]

Use Concat function