Pivot Table Fields
Filters
Columns
Rows
Values
First Name
Last Name
Product Name
Quantity
Price
Total
Product Name
Product Name
First Name
Last Name
Sum
Count
2
7.60
1
5.00
1
3.30
3
12.00
3
7.50
2
7.60
4
13.20
8
32.00
4
10.00
5
19.00
3
15.00
2
6.60
2
8.00
2
5.00
3
11.40
4
13.20
5
20.00
1
2.50
1
3.80
3
9.90
2
5.00
1
5.00
2
6.60
1
4.00
3
7.50
5
19.00
2
6.60
1
4.00
3
7.50
3
11.40
3
15.00
2
6.60
4
16.00
3
7.50
2
7.60
3
15.00
4
13.20
4
16.00
2
5.00
4
15.20
1
5.00
4
13.20
4
16.00
1
2.50
3
11.40
3
15.00
2
6.60
5
20.00
3
7.50
2
7.60
4
20.00
4
13.20
2
8.00
2
5.00
Nancy
Guylene
Sven
Lars
Martin
Ian
Mayumi
Andrew
Michael
Peter
Elio
Cheryl
Caffe Americano
Sum
Count
Peppermint Mocha Twist
Sum
Count
Doubleshot Espresso
Sum
Count
Cappuccino
Sum
Count
Cramel Latte
Sum
Count

Description

This is an example of a Pivot Grid and a Pivot Grid Designer. You can use the pivot grid designer to select which fields will be displayed on rows and columns. You can also select different value fields and choose an aggregation function. Simply drag and drop fields in the respective area and the pivot grid's content will update automatically. You can also click on the menu of each columns, rows, filters or values item and select additional options like text alignment, number formatting and numbers alignment.