Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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