Two approaches to percent of total: SUM([Sales])/WINDOW_SUM(SUM([Sales])) vs. Tableau's quick table calculation. When the manual approach is required for correct scoping.