How to count the ID in the table and keep all the row which ID occur more than one

[eddywong71]

Hi All,

I have a table like below.

ID  Month  Product   

A    Nov      Apple

A    Dec      Apple

A    Oct       Orange

I am using the expression 

AGGR(COUNT( DISTINCT ({Product={'Apple'}, Month=>} Month, ID)

ID  Month  Product    Count

A    Nov      Apple          2

A    Dec      Apple         

A    Oct       Orange

However what I want is

ID  Month  Product    Count

A    Nov      Apple          2

A    Dec      Apple          2 

Have anyone can help to revise my set expression 

[G3S]

try:

aggr(count(distinct Product),ID)