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.
Maybe post some examples, or your application.
Textcount(Distinct PurchaseItem )
You can use count(item).
Retrieving data ...