8 Replies Latest reply: Mar 21, 2016 3:20 AM by ahmar ansari RSS

    Graph and Sum quantites per month

    Beaulieu Mathieu

      Hi,

       

      I have a little problem.

      I have datas like that :

      ItemDateQuantity
      A01/03/20162
      B01/03/20161
      A01/03/20165
      C05/03/20163
      A10/03/20164

       

      In my graph I want to show the quantites per month.

      I have a master calendar.

       

      And, for example, in my graph I want theses values (for March month) :

      A = 11

      B = 1

      C = 3

       

      I can't explain why, but I can't do that...

      In dimension I have "Month" field.

      In Expression I have : =Quantity

      I tried : Sum(Quantity) but with that I get the total sum and I just want the sum per month.

       

      Could you help me?

       

      Thanx for helping me.