Count

[Vaku1606]

Hello, 

I have production data per customer and per item and per date. 

Would like to count the number of items produced per month(and year) per customer (to take into account only items with production qty <>0). To get something like this

	Month
Customer	Jan	Feb	March
CC	13	15	15
Heineken	5	3	12
Pepsi	5	3	1

Could you please help?

Thanks in advance and regards

[BrunPierre]

Perhaps at the front end as below

Count(Aggr(Count({<qty={">0"}>}DISTINCT [Number of Items]),Month,Year,Customer)

[MarcoWedel]

did you try with a pivot table?