1 Reply Latest reply on Mar 22, 2016 10:53 AM by Patrick A Van Der Hyde

    Displaying Store Sales Growth Line With Multiple Average Lines

    Jamie Vinnell

      Hi

       

      I am trying to create a line graph that displays a stores sales growth over time and also displays an average growth of other criteria over the same time period on different lines. I have added a table to try and illustrate my thinking...

       

      Store_Area_Type.JPG

      I would like to be able to filter the line graph by store to show growth for that store only and for it to also show lines for average growth by area and average growth by type i.e. if look at store C growth line, I will also have a line displaying the average growth for Area 1 and Low Type.

       

      Is this something anybody can help with?

       

      Thanks in advance

       

      Jamie