Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

Use Pivot filtering to show specific values from a data field

Applies to: Nevron Chart for SharePoint (WSS3.0, SharePoint 2007/2010/2013)

How to use the Chart web part Pivot filtering to show only specific values from a data field?

In Nevron Chart for SharePoint, you can use Pivot Grouping, Filtering and Sorting.
For this example, we will use the chart from the following topic: Count the number of items for a column by using the SharePoint Chart Pivot

Let’s say that we would like to use filtering in order to show only the “Small Development” and “Large Development” values for the Initiative Type field. We can use a global filter or a category filter.



If we are going to use global filtering, from the Chart Designer >> Pivot tab, in the global Filters tab, we will use the following expression:
=OR(Fields!Initiative_Type="Small Development", Fields!Initiative_Type="Large Development")



If we are going to use category filtering, from the Chart Designer >> Pivot tab, in the Data Groupings >> Categories >> Filters tab, we will add a Filter and use the following expression:
=OR(FIRST (Fields!Initiative_Type)="Small Development", FIRST(Fields!Initiative_Type)="Large Development")



For more details, take a look at the Nevron SharePoint Vision Online Documentation:
Pivot Engine > Expressions
Pivot Engine > Variables

Article ID: 167, Created On: 1/7/2011, Modified: 1/29/2013