How to do this in Brio Reports using Designer 1

[moepower]

Results Table

Orange
Orange
Orange
Apple
Apple
Cherry
Cherry
Apple
Apple
Orange
Orange

How do I go about creating a report that will show me:

Orange 5
Apple 4
Cherry 2

I'm very new to Brio

Thanks,

 

[tallbarb]

Let's assume the item name for your fruits is "Fruits". On the query side, place the Fruits item on the request line twice. For the second Fruits item, right-click and select Data Function, Count. Process. That should do it.