2 Replies Latest reply on Jan 25, 2018 4:09 AM by Zhouyi Zhang

    Counting items different to zero

    Ed Yeldham



      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?