Criteria Usage

The following tables show the usage for each criteria type at each level.

Query Criteria

This table lists the usage for the query criteria type at each level.

Level	Used at this level?	Used alone?	Combined with other criteria?	Restrictions
Cell	Yes	Yes	Filter	When used alone, filter criteria return query column totals. When combined, the filter criteria must be defined in same cell.
Row	Yes	No	Filter	Filter criteria can be defined in cells or intersecting columns.
Column	Yes	No	Filter	Filter criteria can be defined in cells or intersecting rows.
Worksheet	Yes	No	Filter	Filter criteria can be defined in cells only.

Ledger Criteria

This table lists the usage for the ledger criteria type at each level.

Level	Used at this level?	Used alone?	Combined with other criteria?	Restrictions
Cell	Yes	Yes	Filter	When used alone, ledger criteria return ledger amount column totals. When combined, the filter criteria must be defined in same cell.
Row	Yes	No	Filter	Filter criteria can be defined in cells or intersecting columns.
Column	Yes	No	Filter	Filter criteria can be defined in cells or intersecting rows.
Worksheet	Yes	No	Filter	Filter criteria can be defined in cells only.

Label Criteria

This table lists the usage for the label criteria type at each level.

Level	Used at this level?	Used alone?	Combined with other criteria?	Restrictions
Cell	No	N/A	N/A	N/A
Row	Yes	No	Filter	Filter criteria can be defined in cells or intersecting columns.
Column	Yes	No	Filter	Filter criteria can be defined in cells or intersecting rows.
Worksheet	No	N/A	N/A	N/A

Filter Criteria

This table lists the usage for the filter criteria type at each level.

Level	Used at this level?	Used alone?	Combined with other criteria?	Restrictions
Cell	Yes	No	Query, Ledger, and Label.	Query/ledger criteria can be defined in same cell, intersecting rows or columns, or the entire worksheet. Label criteria can be defined in intersecting rows or columns.
Row	Yes	No	Query, Ledger, and Label.	Query, ledger, and label criteria can be defined in intersecting columns.
Column	Yes	No	Query, Ledger, and Label.	Query, ledger, and label criteria can be defined in intersecting rows.
Worksheet	Yes	N/A	N/A	N/A

Variable Criteria

This table lists the usage for the variable criteria type at each level.

Level	Used at this level?	Used alone?	Combined with other criteria?	Restrictions
Cell	Yes	Yes	None	Variables can only be used alone and at the Cell level.
Row	No	N/A	N/A	N/A
Column	No	N/A	N/A	N/A
Worksheet	No	N/A	N/A	N/A

String Criteria

This table lists the usage for the string criteria type at each level.

Level	Used at this level?	Used alone?	Combined with other criteria?	Restrictions
Cell	Yes	Yes	None	Strings can only be used alone and at the Cell level.
Row	No	N/A	N/A	N/A
Column	No	N/A	N/A	N/A
Worksheet	No	N/A	N/A	N/A