4 Replies Latest reply on Aug 7, 2018 3:37 PM by Greg Rafferty

    Display market share over time by product

    Greg Rafferty

      Hi everyone,

      I've created a chart of market share for a single company, for a single product. I use a filter to select which product is displayed:

      Screen Shot 2018-08-07 at 1.56.50 PM.png

      What I want to do is plot every product in the same chart, differentiated by color. I always want to look at only COMPANY 8's market share. I can't seem to figure out how to do it. Every attempt calculates the percentage of total incorrectly. Attached is the workbook. Any suggestions?