13 Replies Latest reply on Oct 15, 2018 9:47 PM by Harry William

# To split the dimension value in a text table

I am completely new to the tableau. I am trying to create a text table in the tableau but facing the following issue :

I am using two different dimensions in row (portfolio type) and column shelf (party type) with a measure (exposure amount), with my column dimension having four values like 'Corporate', 'Individual', 'Bank - PSU' and 'Bank - PVT'. I wanted to split the 'Bank' in the table as follows :

Total = Bank - PSU + Bank - PVT and

Bank - PSU

 Corporate Individual Bank Total Bank - PSU Portfolio 1 Portfolio 2 Portfolio 3 : Portfolio n

Can you suggest the way by which i can generate the above tables based on dimension value for 'Bank'? Whether i can use the calculated field to resolve it?

• ###### 1. Re: To split the dimension value in a text table

Do you have a workbook?

• ###### 2. Re: To split the dimension value in a text table

Hi Harry,

Regards,

Sairam

• ###### 3. Re: To split the dimension value in a text table

Please find the attached work book and a file which i tried to re-create the required dimension.

Regards

Harry William

• ###### 4. Re: To split the dimension value in a text table

Is there any way to incorporate this in the text table along with other dimension :

 Bank Total Bank - PSU
• ###### 5. Re: To split the dimension value in a text table

Hello Harry,

You can try below logic:

Display :

CASE [Party Type Description]

WHEN "Corporate" then ""

WHEN "Individual" then ""

WHEN "Bank - Private" then "Bank"

WHEN "Bank - Public" then "Bank"

END

• ###### 6. Re: To split the dimension value in a text table

Hi Harry,

You can create 4 calculated fields for the dimension values and pull them into your grid as shown in the screenshot below:

The definition of the calculated fields are present in the attached workbook for your reference.

Regards,

Dipankar

• ###### 7. Re: To split the dimension value in a text table

Hi Dipankar,

That helped me to solve the dimension calculation value and values are getting generated fine. But, is there a way by which we can display the text table dimension as follows for party type:

 Corporate Individual Bank Total Bank - PSU

Regards

Harry William

• ###### 8. Re: To split the dimension value in a text table

Hi Harry,

Did you tried the solution given by me??

• ###### 9. Re: To split the dimension value in a text table

Hi,

@Meenu Choudhary, reply will helpful to to get the format mentioned by you.

Regards,

Sairam

• ###### 10. Re: To split the dimension value in a text table

Sairam MVV didn't get you

• ###### 12. Re: To split the dimension value in a text table

Hi All,

I am still not able to  populate the table as follows :

 Corporate Individual Bank Total Bank - PSU

I am attaching the workbook with this mail which i tried to resolve. Can someone please guide me how to resolve the above issue?

Regards

Harry William

• ###### 13. Re: To split the dimension value in a text table

Hi Meenu,

I tried it out, but not able to resolve the issue completely. Can you help me with the attachment that i have added (Account data workbook) and try to suggest any alternatives/resolution

Regards

Harry William