7 Replies Latest reply: Feb 7, 2014 9:48 AM by Srikanth P RSS

    Chart based on latest data

      Hi,

       

      Need to display the latest data based on date and other dimensions.

       

      I need to show the latest stock available in the stores. Need to plot a chart with store in X axis and latest stock information(Based on the date) for that store in y axis.

       

      Data:

       

      Date    Store,  Product,    Stock

      1-Jan,   A,  P1,   100

      2-Jan,   A,  P1,  70

      2-Jan, A,  P2,  20

      1-Jan,  B,  P1,  20

      1-Jan, B, P2,  10

       

      My chart should like like below

      Store,   Stock

      A,  90

      B,  30

      Pls Suggest some solutions.