ADDSLICEAXISLIMIT

This function modifies a slice axis by limiting the number of rows that the slice returns. Optionally, specify a start point for the limit. For example, specify that an axis returns no more than two rows in addition to the first ten rows.

Syntax

=ADDSLICEAXISLIMIT(axis, limit,[start])

If you omit the start point, zero is used.

If you omit the limit, or specify an empty string, then no limit is applied.

Examples

In this example, cell D12 contains an axis created with the CREATESLICEAXIS function. The cell displays #{Axis}. The function limits the number of rows returned by the axis to five.

=ADDSLICEAXISLIMIT(D12,5)

In this example, the number of rows returned is limited to five in addition to the first two rows.

=ADDSLICEAXISLIMIT(D12,5,2)