I do not believe that you can put the % of total in columns without going into a complex process,
If it was just one column, Tableau would put it in a separate column
I have put the % of total under, does this work for you?
1.you need to change the sum duration to % of total
2.you need to add the pile duration in the measure values
3.you need to move it up
4.you can change the format to show no decimals
Share Top5 vs Total.zip 114.8 KB
Thanks for the response. However it doesn't still address my requirement. I do not want a % for each row, but I need for the total of the Top 5 rows. i.e Sum(Top 5 Companies)/Sum(All Companies) for each column
Thanks a lot. This is exactly what I was looking for!
Sorting in Descending order
I have one more query. The advertisers has to be sorted in descending order for each channel by the latest week available in data and select only top 5 advertisers for the latest week and corresponding data from previous 3 weeks.
This activity should be repeated for many channels on a weekly basis. i.e. Sorting in descending order by latest week should happen dynamically.
Every time, when a new week of data is added, the advertisers should automatically get sorted in descending order of the latest week of data and display corresponding data from the previous weeks.
Does anyone have an idea about this view, please share it immediately.