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