I sort of resolving the issue but still not perfect. Since I can't put a percentage number as float but only as string. Then there will be "Abc" on table view.
Formatting.twbx 5.0 KB
1 of 1 people found this helpful
Hi, Qin. Welcome to the Tableau forum! It's a friendly community and you can feel comfortable posing questions.
The attached workbook contains a solution. Transposing your data set was required. This is the way to handle problem you pose. Here's an image of the solution that matches how you want to display the % Share of Voice:
I really do think the best way to approach this problem is to transpose your data set. Now that it's reshaped, every value in the Percent column now represents a percent, every value in Sales represents a sales amount, and every value in the Visits columns represents a number of visits.
Take a look at the workbook. If you have any follow up questions about the workbook, reply back. If this solves your problem, please mark the question as answered. :-)
Thanks for your reply. It solved my problem and that's what I suggested to clients before. However, due to the volume of dataset plus clients' requirement, they still wanna to keep as previous format. (before they wanna further creating new calculate field based on original Column Variables [Change], [Previous], [Current])
Thanks for your answer