Hello

I have some simple sales date over a 5 year period.  I have product code, a classification for each product code (either COM or LEIS) and then summary annual sales data.

I would like to count the number of products sold in a given year against each of the categories.  I produced the table below using CNTD from the quick table calcs on product code.

However having validated in excel it is counting product codes which had zero sales in a given year.  I want to therefore exclude this in the count and for each given year only count the product codes which actually made a sale.  How do I achieve this or do I need to create some sort of calculated field for each year?