2.25
8
18.00
1.50
10
15.00
3.00
4
12.00
2.25
7
15.75
1.50
4
6.00
3.00
8
24.00
2.25
7
15.75
1.50
12
18.00
3.00
16
48.00
2.25
15
33.75
1.50
5
7.50
3.00
14
42.00
2.25
16
36.00
1.50
8
12.00
3.00
6
18.00
2.25
6
13.50
1.50
9
13.50
3.00
7
21.00
2.25
10
22.50
1.50
10
15.00
3.00
4
12.00
2.25
7
15.75
1.50
7
10.50
3.00
10
30.00
2.25
7
15.75
1.50
7
10.50
3.00
10
30.00
2.25
6
13.50
1.50
8
12.00
3.00
10
30.00
2.25
12
27.00
1.50
12
18.00
3.00
13
39.00
2.25
12
27.00
1.50
7
10.50
3.00
9
27.00
Guylene
Michael
Regina
Beate
Sven
Nancy
Ian
Martin
Mayumi
Petra
Cheryl
Lars
Caffe Espresso
sum
count
average
Green Tea
sum
count
average
Black Tea
sum
count
average

Description

This is an example of the pivot grid drill through functionality. It allows you to find the records in the data source which were used to calculate the value of a particular cell in the pivot grid. To drill through a specific grid cell double click on it and you will see a window displaying the source records. In addition to the pivot grid widget, this example uses the window and data table widgets. The example also demonstrates how to handle open and close events of the window widgets and how to enable or disable the selection functionality of the pivot grid component. This demo is implemented using jQuery. You can find similar examples implemented in React JS and Angular inside the React and Angular components section of the website.
Drillthrough records
First name
Last name
Product
Quantity
Unit Price
Total
GuyleneSaylorCaffe Espresso10$3.00$30.00
GuyleneMurphyCaffe Espresso8$3.00$24.00
GuyleneFullerCaffe Espresso8$3.00$24.00
GuyleneOhnoCaffe Espresso2$3.00$6.00
GuyleneVileidCaffe Espresso11$3.00$33.00
GuyleneNagaseCaffe Espresso9$3.00$27.00
GuylenePetersenCaffe Espresso8$3.00$24.00
GuyleneSaylorCaffe Espresso11$3.00$33.00
GuyleneNodierCaffe Espresso9$3.00$27.00
1-9 of 9