Combine values from Two Dimensions in the same table

[sjhussain]

‌Hello,

Hope all is well with everyone.

How can we combine values from two different dimension from while keeping the relationship.

We are working on a dashboard for GL - where we have 3 level of Accounts. 

I have two dimensions from the same table, ACCTID_L2_DESC and ACCTID_CUST

As you can see COS in linked to 7 values in ACCTID_L2_DESC.  What we want to do is to have COS in ACCTID_L2_DESC and when we select COS then it should like to the same 7 values in ACCTID_L2_DESC field.

Will appreciate if someone can assist?

Thanks.

[sunny_talwar]

Do you want this in a list box object or straight table, pivot table? I am confused as to what exactly you want