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.
Syntax
=SLICEGET("slice_unique_name", "rows_tuple_name",
"columns_tuple_name",["property_name"])
The rows and columns tuples can be the cell references of the cells that contain the row and column hyperblocks.
Which optional properties can be used depends on the server.
Example
In this example, the rows hyperblock occupies cells C5:D5 and the columns hyperblock occupies D4:D5. This formula in cell D5 returns values for the slice.
=SLICEGET("slice__unique_name", C5,
D4)