Pulling distinct values from an Object and then counting instances.

[Former Member]

Hello, I'm very new to BO and no one in my business knows how to use BO very well so this might be basics or it might be hard, I'm still too new to know which. I'm basically learning by hammering buttons until I get what I want.

I have a query that gives me a set of data (great) and lets say one column looks like the following

[Fruit]

Apple

Apple

Pear

Grape

Apple

Pear

Apple

How do I get BO to extract all the distinct values and then count how many of each exist in the object? In other words I would like an output of

|Apple | 4|

|Pear | 2|

|Grape | 1|

If it was just excel then I would just use countif's but I cannot work out if I can even do this in BO. Sorry for the incorrect terminology I might be using and thanks in advance

[amitrathi239 · Accepted solution]

Hi,

First drag Fruit object in the table.In the second column paste below formula.

=Count([Fruit];All)

Amit