Group Numbering

To obtain the sequence number of an element within an expanding cell, use the '#' qualifier. (This is useful when you wish to add numbering to row/column headers.)

Walkthrough

For example, consider the formula table from the example in Referencing Cells in Summary Formulas. You will now add numbering for the expanding row header cell 'st'.

1. Expand the Style Studio Properties panel.

2. Right-click any cell in the first column and select 'Column' > 'Insert Column' from the context menu. This adds a new column to the left.

3. Select cell[1,0] (second row) in the newly inserted column.

Do not specify any cell expansion. Note that numbering starts with 0, hence the '+1'.

4. Select the Data tab in the Properties panel. In the 'Binding' panel, select the 'Formula' option, and add the formula '$st['#'] + 1'.

5. Select the Option tab. Enable 'Merge expanded cells', and select 'st' from the 'Row Group' menu.

Note: The toList() function extracts a unique list of values from a given array. It can also extract a unique set of years, months, etc., from a set of date fields.

6. Select cell[1,1] (second row, second column) in 'State' column. Under the Data tab, change the formula to 'toList(q['state'])', which will show only unique values.

7. Under the Option tab, select 'Merge expanded cells', and select 'st' from the 'Row Group' menu.

8. Select cell[1,2] (second row, third column) in the 'City' column. Under the Data tab, change the formula to 'toList(q['city@state:$st'])', which will show only unique values.

9. Select cell[1,3] (second row, fourth column) in the 'Count' column. Under the Option tab, select 'Merge expanded cells', and select 'ct' from the 'Row Group' menu.

The table should appear as shown below:

 

10. Preview the report and notice the numbering of the groups.

 

<< Referencing Cells in Summary Formulas © 1996-2013 InetSoft Technology Corporation (v11.5) Referencing a Cell with Relative Parent Group Reference >>