expression for aggr and count

[zacsyuan]

I want to replicate the count column( the fourth column) of excel to a Qlik plain table chart by using expression

I assume aggr and count would be used ...tried a few variations, no luck 

so each sku has different product type, if it has 4 , the count column should show distinct count of 4, if it has 3, then it returns 3. 

SKU	Product type	CONT_TYPE	COUNTIFS($A$2:$A$996,A2)
6403	A	Regular	4
4401	D	Regular	3
6403	D	Regular	4
4401	C	Regular	3
4401	B	Regular	3
6403	B	Regular	4
6403	C	Regular	4

[Or]

Count(Distinct Total <SKU> [Product type]) perhaps?

[BrunPierre · Accepted solution]

As below.

=Count(TOTAL <SKU> SKU)