Add Up count values

[Anonymous]

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

[sunny_talwar]

Because the way this is structured, you probably won't be able to do a distinct count here. I think, to handle this, you would need to use The As-Of Table‌ because this approach will be the easiest in handling any issues that you are having regarding a distinct counting