Frequency Question

[mphekin12]

I have the following data that is pretty straight forward.  It is a Product ID and the number of time that product has been sold:

What I need is to be able to display the frequency of the 'Time Sold' column, so my data should look similar to this:

Any suggestions on how I can accomplish this?

Thank you!

[swuehl · Accepted solution]

Try a calculated dimension like

=Aggr(Count(ProductID), ProductID)

and

=Count(DISTINCT ProductID)

as expression

[mphekin12]

Stephan,

That seemed to do the trick.

Thank you so much for your help!