1 of 1 people found this helpful
Victor, is this what you want to achieve? (I apologize for using a pie chart...)
If so, it's easy, with one tiny complication.
I'm using the Superstore sample data, with Region for the slices and Sum(Sales) for the values.
The first step is easy: Drag "Sales" to the "Text" mark. That will create the numeric value on the chart.
This is the "harder" part: RIGHT-CLICK and drag "Sales" onto the "Text" mark, and this time select a different aggregation - I usually do "AVG". You have to do this because Tableau will not let you put the same value into a viz twice. Changing the aggregation lets you get the FIELD into the view a second time so that you can manipulate it to get the result you want.
Now, right-click on that AVG(Sales) field, and select "Quick Table Calculation". Select "Percent of Total".
Finally, right-click one more time, and change the aggregation to SUM (from AVG). You should now have the numeric value and the percentage value for each data point.
If that's not what you're looking for, let me know and I'll revise the above!
Thank you Michael, this is exactly what i want to do, I cannot try now and will post again if I did not manage to do it.
Thank you anyway,