2.25
9
20.25
1.50
7
10.50
3.00
8
24.00
2.25
8
18.00
1.50
7
10.50
3.00
9
27.00
2.25
7
15.75
1.50
8
12.00
3.00
8
24.00
2.25
9
20.25
1.50
14
21.00
3.00
11
33.00
2.25
13
29.25
1.50
9
13.50
3.00
10
30.00
2.25
9
20.25
1.50
11
16.50
3.00
7
21.00
2.25
8
18.00
1.50
11
16.50
3.00
14
42.00
2.25
9
20.25
1.50
18
27.00
3.00
12
36.00
2.25
16
36.00
1.50
8
12.00
3.00
11
33.00
2.25
7
15.75
1.50
8
12.00
3.00
4
12.00
2.25
10
22.50
1.50
8
12.00
3.00
15
45.00
2.25
9
20.25
1.50
8
12.00
3.00
8
24.00
Guylene
Andrew
Petra
Peter
Cheryl
Nancy
Martin
Sven
Ian
Michael
Beate
Yoshi
Caffe Espresso
sum
count
average
Green Tea
sum
count
average
Black Tea
sum
count
average

Description


This is an example of Pivot Grid with SubTotals and GrandTotals. The pivot grid can display SubTotals and/or GrandTotals.
It is also possible to configure different totals settings for the pivot rows and the pivot columns. To change the default settings
modify the totals property of the pivot data adapter.