4 Replies Latest reply: Jul 7, 2016 3:49 AM by Vineeth Pujari RSS

    Only previous month's data in a bar chart?

    Divya Anand

      Hi all, I hope someone out there can help me with this.

       

      I have 3 fields- Month, region, sales.

      I want to see a bar chart with only the previous month's sales with the Region on x-axis.

       

      For ex, if the data I have is this:

      MonthRegionSales
      marnorth78518751
      junenorth28632982
      junewest2378638
      junecentral2369386
      julysouth8136328
      junesouth3863893

       

      Now I want to see a bar chart which shows values (north, west, central, south) on x-axis (Since June is the previous month) with respective values on the bars.

       

      Thank you.