3.50
4
$16.00
14.89
3
$11.40
0.00
1
$5.00
0.00
2
$8.00
4.00
2
$7.60
0.25
2
$10.00
4.00
2
$8.00
0.00
1
$3.80
4.00
2
$10.00
2.00
3
$12.00
0.89
3
$11.40
0.00
1
$5.00
$
7.44
5
$19.00
1.50
4
$20.00
13.56
3
$12.00
0.22
3
$11.40
2.89
3
$15.00
$
2.25
2
$7.60
12.19
4
$20.00
6.25
2
$8.00
6.22
3
$11.40
0.00
1
$5.00
1.00
2
$8.00
1.00
2
$7.60
3.56
3
$15.00
6.25
4
$16.00
6.69
4
$15.20
0.00
1
$5.00
0.25
2
$8.00
8.96
5
$19.00
0.25
2
$10.00
4.24
5
$20.00
4.00
2
$7.60
8.22
3
$15.00
Michael
Yoshi
Nancy
Andrew
Regina
Beate
Petra
Sven
Shelley
Mayumi
Peter
Martin
Cappuccino
sum
count
variance
Cramel Latte
sum
count
variance
Peppermint Mocha Twist
sum
count
variance

Description

This is an example of the Vue Pivot Grid with custom a custom data aggregation function. The pivot grid component provides several built-in functions: count, sum, min, max, average, product. In this example, we implement a custom function that calculates the variance of the data points of the respective pivot grid cell. To add or modify existing data aggregations, set the customAggregationFunctions property of the pivot data source. Each pivot aggregation functions must have a unique name, take an array of values as a parameter and return a number. For performance reasons, make sure that the function runs as quickly as possible. The Vue pivot grid will call the function multiple times during the data pivoting operations.