Pivot's Aggregates Computations
The example shows how to compute custom aggregates
|
Sales | Distinct product lines | Sales per distinct line
|
2004
|
2005
|
Total
|
||||||||||||||||
|
October
|
November
|
Total
|
March
|
Total
|
|||||||||||||||
|
Sales
|
Distinct product lines
|
Sales per distinct line
|
Sales
|
Distinct product lines
|
Sales per distinct line
|
Sales
|
Distinct product lines
|
Sales per distinct line
|
Sales
|
Distinct product lines
|
Sales per distinct line
|
Sales
|
Distinct product lines
|
Sales per distinct line
|
Sales
|
Distinct product lines
|
Sales per distinct line
|
||
|
AV Stores, Co.
|
Classic Cars
|
$16,414
|
1
|
$16,414
|
$18,324
|
1
|
$18,324
|
$34,738
|
1
|
$34,738
|
-
|
-
|
-
|
-
|
-
|
-
|
$34,738
|
1
|
$34,738
|
|
Ships
|
$19,186
|
1
|
$19,186
|
-
|
-
|
-
|
$19,186
|
1
|
$19,186
|
-
|
-
|
-
|
-
|
-
|
-
|
$19,186
|
1
|
$19,186
|
|
|
Trains
|
$7,874
|
1
|
$7,874
|
-
|
-
|
-
|
$7,874
|
1
|
$7,874
|
-
|
-
|
-
|
-
|
-
|
-
|
$7,874
|
1
|
$7,874
|
|
|
Vintage Cars
|
$9,352
|
1
|
$9,352
|
$28,835
|
1
|
$28,835
|
$38,187
|
1
|
$38,187
|
-
|
-
|
-
|
-
|
-
|
-
|
$38,187
|
1
|
$38,187
|
|
|
Total
|
$52,825
|
4
|
$13,206
|
$47,159
|
2
|
$23,580
|
$99,984
|
4
|
$24,996
|
-
|
-
|
-
|
-
|
-
|
-
|
$99,984
|
4
|
$24,996
|
|
|
Alpha Cognac
|
Ships
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
$12,432
|
1
|
$12,432
|
$12,432
|
1
|
$12,432
|
$12,432
|
1
|
$12,432
|
|
Total
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
$12,432
|
1
|
$12,432
|
$12,432
|
1
|
$12,432
|
$12,432
|
1
|
$12,432
|
|
|
Total
|
$52,825
|
4
|
$13,206
|
$47,159
|
2
|
$23,580
|
$99,984
|
4
|
$24,996
|
$12,432
|
1
|
$12,432
|
$12,432
|
1
|
$12,432
|
$112,417
|
4
|
$28,104
|
|