If a report
displays data which is of particular interest or is unexpected, you can isolate
the data and the elements to which it relates.
Click the cell or cells which are of interest.
To select multiple cells, press and hold <Ctrl> key and
select each cell.
Click
Keep
Elements in the Alea Ad-hoc Report group on the ribbon.
Only the selected values are displayed - in the order in
which you selected them.
Note: There is no undo option for the Keep Elements function. To undo
selections made in this way, open the
Dimension Browser and reselect the original
elements.