Previous | Next | Contents | Index | Navigation | Glossary | Library |
Row Name: Use this name to reference this row when defining calculations or using other forms. This name does not appear on any reports.
Note: If you plan to use row names in calculations, make sure the row names are unique within the row set.
Percent of Row: Enter a value for a percentage column. This value is the sequence number of the row you want to use as the percentage denominator. For example, if you want to define the report below, enter the sequence number of the total sales row (40) in the Percent of Row field for every row. Then in your column set, define a calculation column which calculates percent on the sales column, using the operator % and the column sequence 10.
Column 10 | Column 20 | ||
Sales | % of Total Sales | ||
Row 10 | 100 | 10 | |
Row 20 | 400 | 40 | |
Row 30 | 500 | 50 | |
Row 40 (Total) | 1000 | 100 |
Previous | Next | Contents | Index | Navigation | Glossary | Library |