1.50
5
7.50
3.00
6
18.00
2.25
8
18.00
1.50
7
10.50
3.00
8
24.00
2.25
7
15.75
1.50
7
10.50
3.00
9
27.00
2.25
3
6.75
1.50
7
10.50
3.00
12
36.00
2.25
8
18.00
1.50
9
13.50
3.00
11
33.00
2.25
9
20.25
1.50
7
10.50
3.00
14
42.00
2.25
10
22.50
1.50
5
7.50
3.00
10
30.00
2.25
11
24.75
1.50
14
21.00
3.00
15
45.00
2.25
9
20.25
1.50
12
18.00
3.00
12
36.00
2.25
12
27.00
1.50
9
13.50
3.00
7
21.00
2.25
5
11.25
1.50
8
12.00
3.00
10
30.00
2.25
8
18.00
1.50
8
12.00
3.00
17
51.00
2.25
4
9.00
Regina
Michael
Nancy
Antoni
Cheryl
Lars
Guylene
Peter
Andrew
Shelley
Petra
Elio
Black Tea
sum
count
average
Caffe Espresso
sum
count
average
Green 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
ReginaNagaseBlack Tea6$2.25$13.50
ReginaWinklerBlack Tea9$2.25$20.25
ReginaRossiBlack Tea10$2.25$22.50
ReginaWinklerBlack Tea10$2.25$22.50
1-4 of 4