5 Replies Latest reply: Sep 17, 2016 6:46 AM by Digvijay Singh RSS

    Bar Chart like Pivot Table

    Dave Melillo

      I want to create a chart with ACCOUNT GROUPINGS on the Y Axis and MONTH on the X axis

       

      The main expression would be SUM of SALES, therefore showing the fluctuation of sales over time by ACCOUNT GROUPINGS

       

      I can easily do this with a pivot table chart, but I would like to create a visualization such as a line or bar. There should be a SEPARATE bar/line for every possible value of ACCOUNT GROUPINGS which share the same MONTH X axis.

       

      Is this possible?

       

      Bonus: I would also like to display percentage change month over month for each individual account grouping.

       

      Thank you,

       

      - dave