PivotTable's and PivotMatrix's multiple options

Options for hiding subtotal rows and columns, showing data headers, mapping fields, headers and data cells 


PivotTable::create(array(
    ...
    'hideSubtotalRow' => true,
    'hideSubtotalColumn' => true,
    'showDataHeaders' => true,
    ...
));



PivotMatrix::create(array(
    ...
    'hideSubtotalRow' => true,
    'hideSubtotalColumn' => true,
    'showDataHeaders' => true,
    ...
));
 
  dollar_sales - sum   dollar_sales - count  
  orderYear   orderQuarter  
  customerName   productLine   productName  
2004
2005
Total
Total
Total
dollar_sales - sum
dollar_sales - count
dollar_sales - sum
dollar_sales - count
dollar_sales - sum
dollar_sales - count
AV Stores, Co.
Total
Amica Models & Co.
Total
Anna's Decorations, Ltd
Total
Alpha Cognac
Total
Atelier graphique
Total
Total
$99,984
$35
-
-
$99,984
$35
$82,223
$26
-
-
$82,223
$26
-
-
$56,932
$19
$56,932
$19
-
-
$12,432
$5
$12,432
$5
$7,743
$3
-
-
$7,743
$3
$189,951
$64
$69,365
$24
$259,315
$88
Page size:
Description