| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Excel Range Slicers/Version 7.0
Revision as of 12:02, 19 March 2012 by Antonio.remedios (talk | contribs) (Created page with "<noinclude>{{VersionDisambiguation|pageVersion=|disambiguationPage=Excel Range Slicers/Versions}}</noinclude> In the scenario where a Slicer needs to be used to allow the selecti...")
 |
This article refers to the latest XLCubed version. For other versions, see Excel Range Slicers/Versions. |
In the scenario where a Slicer needs to be used to allow the selection of an item from a range of cells, then have the corresponding selection passed to another report as a parameter, Excel range driven slicers can be useful.
The screenshot below shows a selection list containing five countries, each with its corresponding country code. When the user selects a country, its corresponding country code should be displayed.
This can be done through an XLCubed slicer. Create a slicer as follows:
- Select the XLCubed > Slicer > Excel ribbon item.
- Set the Slicer range to =$A$1:$B$5 (this is the range of cells where the country code and country name are held).
- In the Properties section, check Update range with selection, select First Column and enter the cell location where you want the country code to be displayed. In our example it is B11.
- When the user clicks on a slicer option, in this case France, its corresponding country code is displayed in cell B11.
