10 Replies Latest reply: Jan 3, 2017 7:16 AM by Sunny Talwar RSS

    Add Up count values

    s Walter

      Hi,

       

      i want to add up count values. I try it like this, but it doesn´t work:

       

      Count({<[prodYear] = {"$(=getfieldselections(Year))"},[prodMonth] = {"Nov"}>}products) + Count({<[prodYear] = {"$(=getfieldselections(Year))"},prodMonth = {"Okt"}>}products)

       

      The dimension in this chart is prodMonth.

       

      My target is to add up allways the number of products for the last three month.

       

      In Sep i want the sum of products for Jul, Aug, Sep

      In Okt i want the sum of products for  Aug, Sep, Okt

      etc.

       

      How can i do it?

       

      regards,

      sam