Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Maybe post some examples, or your application.
Antoine
Textcount(Distinct PurchaseItem )
COUNT(Distinct ITEMS)
See attached.
Hi,
You can use count(item).
HTH
-Shruti
=Max(Count(Itemname))