how to apply this in a piviot table Element #2: Proportion of Sales Revenue by Product On your "Other Calcs" worksheet create a new pivot table from the Raw Data Table. Use Product in the rows and present the total sales revenue for each product in the current year as a % of the total sales revenue. Sort it from largest to smallest percentage. To make it cleaner, only show those products whose sales are 15% or more of the total in the current year and group the other products together to represent "all other" products. Make a chart of this and put it on your dashboard. Be sure your final chart does not show the details of what is in "All other". You must determine the proper type of chart to show. Make a note of how many products had to be combined in the "all other" group