Specify Target Cells

<< Click to Display Table of Contents >>

Navigation:  Version 6 Enhancements > Enhanced Data Analyzer > Pivot Table / Analyzer User Interface > Data Presentation > Filter Data > Filter Data by Cell Values >

Specify Target Cells

 

Filtering by cell values is applied only to regular cells by default. You can change this behavior and apply it to Total or Grand Total cells. To do this, check the Apply to specific level check box, and select column and row fields that identify the desired Total or Grand Total cells.

img16909