Hello.
How do I count and report the number of occurances of a item?
I'm trying to do a report where I simply need to retrieve how many times each item occurs in the report and create a chart for that.
FOr example the output as follows:

Item
Apple
Orange
Mango
Orange
Orange
Mango
Apple

From the results above how do I get a report that says:

Item | Amount
Apple | 2
Mango | 2
Orange | 3

Total Fruits |7

(The "|" is my lame attempt at denoting a separate column )

Thanks for you help!

S