Comece agoraComece grátis

Market Share

Now that you have an idea of how big the total annual category is, let's try to identify the market share of the biggest players on the market. We'd like to create a table to see how our brands evolved over the years.

Este exercicio faz parte do curso

Estudo de Caso: Net Revenue Management no Google Sheets

Ver curso

Instruções do exercicio

  • Create a new PivotTable to calculate the total value sales per year, per brand in a new worksheet called "Market Share".
  • Display the values as a % of grand total, with each year adding up to 100%.
  • Make sure to add Brand to Rows and Year to Columns.
  • Order in descending order for "Sum of Values Month" using the "Grand Total", using and make sure the total adds up to 100% for each year.

exercicio interativo prático

Transforme teoria em prática com um dos nossos exercicio interativos

Iniciar exercicio