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

    Add Up count values

    s Walter



      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



      How can i do it?