AGGR Function

[Anonymous]

I am trying to create a relative frequency using the AGGR function.  I have a snapshot of the data as it is exported to Excel.

I would like to divide each count by the total count for each product code.  All rows other than a randomly chosen row are showing up as missing.

[MK_QSL · Accepted solution]

=Count(AcctNum)/Count(Total <ProductCode> AcctNum)

Use Distinct if necessary..