Page History

On a pivot grid panel, the user will need to click on the row field to view sorting and filtering option.

 16.1Image Removed

16.2

Image Removed

Here's how it looks like:

16.1

Image Removed

16.2

Image Removed

There are 2 types of filtering options:

Through Label Filters

Records are being filtered based on the row you clickedselected. Here's how to use it:

1. Go to the row you would like to filter record. Select Label Filters and condition.
   16.1
   Image Removed
   16.2
   Image RemovedImage Added
   
   
2. Type in the value on the text field on the Label Filter screen.
   16.1
   Image Removed
   16.2
   Image RemovedImage Added
   
   
3. Click OK button.
   16.1
   Image Removed
   16.2
   Image Removed

...

1. Image Added

Through Value Filters

The user can filter through Aggregate/Data fields. Here's how to use it:

1. Click any row to filter record. Select Value Filters and condition.
   16.1
   Image Removed
   16.2
   Image RemovedImage Added
   
   
2. On the Value Filter screen, select data field on "Show items for which" field and type in value on the text field.
   16.1
   Image Removed
   16.2
   Image RemovedImage Added
   
   
3. Click OK button.
   16.1
   Image Removed
   16.2
   Image Removed

1. Image Added

If Case Sensitive checkbox is checked, the pivot grid panel will return records based on the entered value having the same casing with the existing records.

...