Referencing Cells in Summary Formulas
Walkthrough
Consider the formula table from the previous example in Referencing a Cell for Column Filtering. It consists of a two-level row header listing 'States' and 'Cities within a State'.
In the following example, you will add a formula to count the number of customers within each city.
1. Add the following formula to cell[1,2] (second row, third column):
count(q['customer_id@state:$st;city:$ct'])
This counts all the customers within the given city and state. The table should now appear as shown below.

2. Preview the report and note the output.
| << Referencing a Cell for Column Filtering | © 1996-2013 InetSoft Technology Corporation (v11.5) | Group Numbering >> |