Number Card - Sales Invoice Doc Type - Count of qty. sold of specific "Item Category"


i am creating a Number Card based on Sales Invoice Doc Type where i want sum of Qty. sold for a specific “Item Category”. But in the “Aggregate Function Based On” field, there is selection of only “Total Quantity” - i.e total qty. of items in the invoice. There is no option to select the field “Quantity” field - i.e. the individual line item Quantity - which i actually need.

Let me explain to you directly that if you want to do all these things then do one thing first. You first create a report according to this requirement. And make a number card from that report. So it will be easy for you and your requirements will also be fulfilled.