11 Replies Latest reply on Jul 12, 2018 1:30 AM by Wong Michael

# create two column in the right side of a table by Caculated field

Does anyone can help me ,thanks!

There 's my issue. I need to create two column automatically like the figure below (yellow zone ),which based on the white zone.Appraciate for you times!

• ###### 1. Re: create two column in the right side of a table by Caculated field

Hello Wong,

My solution is to use dashbaord.

For the calculation of the yellow zone, LOD is used.

Regards

Lei

1 of 1 people found this helpful
• ###### 2. Re: create two column in the right side of a table by Caculated field

Hi Michael,

You can use table calculations and do it in tableau.Lot of stuff in the internet.

few examples:

BR,

bharat

• ###### 3. Re: create two column in the right side of a table by Caculated field

Excellent! It does works. And i still have a question about how can u hide the row STORE int the worksheet RIGHT  Lei Chen

• ###### 4. Re: create two column in the right side of a table by Caculated field

Hello Wong,

Just simply uncheck "Show Header" for [STORE].

Regards

Lei

• ###### 5. Re: create two column in the right side of a table by Caculated field

GOT IT! Many thanks

• ###### 6. Re: create two column in the right side of a table by Caculated field

I got the answer I want from Miss LEI.Well, Thanks a lot .

• ###### 7. Re: create two column in the right side of a table by Caculated field

Hi, Lei

Do you know how to create new column(yellow zone) ,which means the comparison between two exist column(white zone).

Thank you~

Wong

• ###### 8. Re: create two column in the right side of a table by Caculated field

Hello Wong,

Wong Michael wrote:

Do you know how to create new column(yellow zone) ,which means the comparison between two exist column(white zone).

I'd like to confirm about the requirement.

Do this mean that, for example,

you want to add a column (with background color yellow) between "JAN" column and "FEB" column, showing the difference of value between these two month?

Regards

Lei

• ###### 9. Re: create two column in the right side of a table by Caculated field

What I mean is  the growth rate. Specifically, for example, In June， the sales of the store in CA is 50 ，while it went to  60 next month(JULY) .Therefore ,the growth rate is ( 60 -50 ) / 50 =20%. Actually， “20%“ is what exactly I need. Moreover,  the new column (with background color yellow) should be putting on the right side of the table.

Thanks

Wong

• ###### 10. Re: create two column in the right side of a table by Caculated field

Hello Wong,

I added month growth rate to the workbook, and also played a little with your data

As a result, there are three layout / viz examples in the attached workbook.

Regards

Lei

• ###### 11. Re: create two column in the right side of a table by Caculated field

Yeah, it works perfectly!  Many thanks, honey