Page History

...

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

Image Removed

Here's how it looks like:

Image Removed

There are 2 types of filtering options:

Through Label Filters

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

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

Through Value Filters

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

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

...

If Case Sensitive checkbox is unchecked, the pivot grid panel will return records based on the entered value even if the entered value does not have the same casing on the existing records.

...