---
layout: post
title: Data-Exploration
description: data exploration
platform: emberjs
control: PivotClient
documentation: ug
---

# Data exploration

## Filtering

### Filtering by member

By clicking the split button of a field, the member editor dialog opens through which members are filtered by checking and unchecking the check boxes corresponding to members.

![](Data-Exploration_images/relational-filterbymember.png)

By clicking OK, the pivot report gets updated and the pivot grid and pivot chart controls get refreshed based on selected members in the member editor dialog. The Cancel button is used to cancel the selection.

![](Data-Exploration_images/relational-filter-grouping.png) 

The above filter illustrates the members 'Canada' and 'Germany' that are alone included in the grid and chart controls.

## Grouping

The data can be grouped when more than one field is added to columns or rows in the axis element builder. Based on the order of addition, the data is grouped and the report is updated. In the following example, the **Date** field values get grouped with respect to **Country** field values. Likewise, multiple field members can be grouped by dragging the fields from pivot fields list to the axis element builder.

![](Data-Exploration_images/relational-grouping.png)

## Searching

Members can be searched and displayed from the members list in the member editor dialog.

![](Data-Exploration_images/relational-search-grouping.png)