Business Objects CountIf by cell reference
<p>So I have a column with this data</p>

<pre><code>1
1
1
2
3
4
5
5
5
</code></pre>

<p>how can I do a count if where the value at any given location in the above table is equal to a cell i select? i.e. doing <code>Count([NUMBER]) Where([NUMBER] = Coordinates(0,0))</code> would return 3, because there are 3 rows where the value is one in the 0 position.</p>

<p>it's basically like in excel where you can do <code>COUNTIF(A:A, 1)</code> and it would give you the total number of rows where the value in <code>A:A</code> is 1. is this possible to do in business objects web intelligence? </p>