| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Excel Range Slicers/Version 6.5"
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | <noinclude>{{VersionDisambiguation|pageVersion=6.5 and older|disambiguationPage=Excel Range Slicers/Versions}}</noinclude> | |
| + | =Slicer From a Range= | ||
| + | |||
| + | Excel slicers allow the creation of a custom slicer, rather than one based on members in a cube. They are useful 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. | ||
| + | |||
| + | The slicer type, size and positioning can be formatted just as for [[Dimension Slicers]]. | ||
| + | |||
| + | ==Creating a Range Slicer== | ||
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. | 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. | ||
| Line 7: | Line 14: | ||
This can be done through an XLCubed slicer. Create a slicer as follows: | This can be done through an XLCubed slicer. Create a slicer as follows: | ||
| − | # On the '''Selection''' tab, set '''Slicer range''' to =$A$1:$B$5 (this is the range of cells where the country code and country name are held). [[Image:Slicer2.png|350px|centre]] | + | # On the '''Selection''' tab, set '''Slicer range''' to =$A$1:$B$5 (this is the range of cells where the country code and country name are held). |
| − | # On the '''Settings''' tab, check '''Update range with selection''', select '''Unique Name''' and enter the cell location where you want the country code to be displayed. In our example it is B11. [[Image:Slicer3.png|350px|centre]] | + | |
| − | # When the user clicks on a slicer option, in this case France, its corresponding country code is displayed in cell B11. [[Image:Slicer4.png|350px|centre]] | + | [[Image:Slicer2.png|350px|centre]] |
| + | |||
| + | # On the '''Settings''' tab, check '''Update range with selection''', select '''Unique Name''' and enter the cell location where you want the country code to be displayed. In our example it is B11. | ||
| + | |||
| + | [[Image:Slicer3.png|350px|centre]] | ||
| + | |||
| + | # When the user clicks on a slicer option, in this case France, its corresponding country code is displayed in cell B11. | ||
| + | |||
| + | [[Image:Slicer4.png|350px|centre]] | ||
| + | |||
[[Category:Slicers]] | [[Category:Slicers]] | ||
Latest revision as of 11:11, 28 August 2018
 |
This article refers to XLCubed version 6.5 and older. For other versions, see Excel Range Slicers/Versions. |
Slicer From a Range
Excel slicers allow the creation of a custom slicer, rather than one based on members in a cube. They are useful 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.
The slicer type, size and positioning can be formatted just as for Dimension Slicers.
Creating a Range Slicer
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:
- On the Selection tab, set Slicer range to =$A$1:$B$5 (this is the range of cells where the country code and country name are held).
- On the Settings tab, check Update range with selection, select Unique Name 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.
