Difference between revisions of "User:Antonio.remedios/PdfTestPage"

(Cascading and Advanced Slicers)
Line 3: Line 3:
 
Slicers have a filter area in their definition, which can be used to restrict the members returned based on the presence of data. The example below shows the design for a slicer for ‘Product Model Categories’ which is being filtered on ‘Geography’ based on what has been selected in the slicer at Sheet1!$C$3.
 
Slicers have a filter area in their definition, which can be used to restrict the members returned based on the presence of data. The example below shows the design for a slicer for ‘Product Model Categories’ which is being filtered on ‘Geography’ based on what has been selected in the slicer at Sheet1!$C$3.
  
[[Image:AdvancedSlicer1.png|750px|centre]]
+
[[Image:AdvancedSlicer1.png|700px|centre]]
  
 
[http://www.xlcubed.com/help/index.php?title=Category:PdfTestCategory&action=pdfbook]
 
[http://www.xlcubed.com/help/index.php?title=Category:PdfTestCategory&action=pdfbook]
  
 
[[Category:PdfTestCategory]]
 
[[Category:PdfTestCategory]]

Revision as of 13:47, 2 August 2012

Cascading and Advanced Slicers

Slicers have a filter area in their definition, which can be used to restrict the members returned based on the presence of data. The example below shows the design for a slicer for ‘Product Model Categories’ which is being filtered on ‘Geography’ based on what has been selected in the slicer at Sheet1!$C$3.

AdvancedSlicer1.png

[1]