SLICEGET

SLICEGET returns values for a slice. If you change the value of the cell that contains the SLICEGET formula, the value is written back to the database.

When you create a slice, row and column objects are created. Hyperblocks are created if you drag a slice into a report or if you drag the column and rows separately. If you drag the slice to a report, overlapping hyperblocks are created. The value cell where the hyperblocks overlap automatically contains a SLICEGET formula that returns the value of the slice.

See Adding a slice to a report.

Syntax

=SLICEGET("Slice unique name", "Rows tuple name", "Columns tuple name", "Optionals: Property name")

The rows and columns tuples can be the cell references of the cells that contain the row and column hyperblocks.