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.4) Group Numbering >>