The percent of the group/pivot total will give you the percentage of each value in a group out of the total sum of the values for that group.
column_i_want_to_see_the_percent_of_total
- this is the column that you want to see the percent total of. In our example above, that was the sum of profit
.column_i_want_to_group_by
- this is the column that you want the total to be grouped by. In our example above, that was the order date - week
.format
tab, make sure to update the format to percent
so that your table calculation is shown as a percentage value (instead of a number).