Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Through Label Filters

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

  1. Go to the row you would like to filter record. Select Label Filters and condition.
    Image Added

  2. Type in the value on the Label Filter screen.
    Image Added

  3. Click OK button.
    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.
    Image Added

  2. On the Value Filter screen, select data field on "Show items for which" field and type in value on the text field.
    Image Added

  3. Click OK button.
    Image Added

 

Info
titleNote

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.

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.

Expand
title16.1

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

...

Image Modified

...

                                                                                                     

...

Image Modified

...

Here's how it looks like:

...

Image Modified

 

...

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

...

  1. .

...


  1. Image Modified

...

...


  1. Type in the value on the text field on the Label Filter screen

...

  1. .

...


  1. Image Modified

...

  1. Click OK button.

...

  1. Image Modified

...

 

 

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.

...

  1. Image Modified

...


...


  1. On the Value Filter screen, select data field on "Show items for which" field and type in value on the text field

...

  1. .

...


  1. Image Modified

...

  1. Click OK button

...

  1. .

...


  1. Image Modified

...


 

Info
titleNote

If Case Sensitive checkbox is unchecked,

the

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.

If Case Sensitive checkbox is checked,

the

the pivot grid panel will return records based on the entered value having the same casing with the existing records.

Expand
title15.3

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

Here's how it looks like:

 

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.
  3. Type in the value on the text field on the Label Filter screen.
  4. Click OK button.

 

 

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.
  3. On the Value Filter screen, select data field on "Show items for which" field and type in value on the text field.
  4. Click OK button.

 

Info
titleNote

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.

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.

...