$2.25
13
$29.25
$1.50
8
$12.00
$3.00
9
$27.00
$2.25
4
$9.00
$1.50
11
$16.50
$3.00
6
$18.00
$2.25
7
$15.75
$1.50
10
$15.00
$3.00
11
$33.00
$2.25
11
$24.75
$1.50
10
$15.00
$3.00
5
$15.00
$2.25
9
$20.25
$1.50
13
$19.50
$3.00
9
$27.00
$2.25
9
$20.25
$1.50
8
$12.00
$3.00
6
$18.00
$2.25
7
$15.75
$1.50
6
$9.00
$3.00
5
$15.00
$2.25
9
$20.25
$1.50
10
$15.00
$3.00
10
$30.00
$2.25
11
$24.75
$1.50
6
$9.00
$3.00
10
$30.00
$2.25
8
$18.00
$1.50
6
$9.00
$3.00
10
$30.00
$2.25
8
$18.00
$1.50
11
$16.50
$3.00
14
$42.00
$2.25
10
$22.50
$1.50
7
$10.50
$3.00
8
$24.00
$2.25
10
$22.50
$1.50
11
$16.50
$3.00
8
$24.00
Elio
Yoshi
Ian
Antoni
Regina
Petra
Sven
Beate
Martin
Lars
Cheryl
Shelley
Nancy
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.