Purchase frequency of Items

[siva0606]

Hi all,

For Example,

I have many number of items in item table and i have to calculate Which item is purchased more number of times(frequency of item)?

Please help me in the expression part.

Regards,

Sivasu

[Anonymous]

Hi,

Maybe post some examples, or your application.

Antoine

[ashwanin]

Textcount(Distinct PurchaseItem )

[MK_QSL]

COUNT(Distinct ITEMS)

[#5]

See attached.

[#6]

Hi,

You can use count(item).

HTH

-Shruti

[Anonymous]

=Max(Count(Itemname))