Warning: session_write_close() [function.session-write-close]: write failed: No space left on device (28) in /home/www/plugtest.opendocsociety.org/htdocs/doku.php on line 116

Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php5) in /home/www/plugtest.opendocsociety.org/htdocs/doku.php on line 116

Warning: Cannot modify header information - headers already sent by (output started at /home/www/plugtest.opendocsociety.org/htdocs/doku.php:116) in /home/www/plugtest.opendocsociety.org/htdocs/inc/actions.php on line 217
PivotTable [plugtest.opendocsociety.org]



Disclaimer: You are free to reuse it “as-is”, on your own responsibility and without any guarantee whatsoever. No rights can be derived from, successfully or unsuccessfully, completing the steps outlined below.


  1. Open data.ods (sample data file with 5000 rows)
  2. Insert a Pivot Table (data pilot) on a new worksheet, based on the entire range of the data. (In Excel – Insert/PivotTable/OK.)
  3. Add these three fields/columns to the PivotTable: Product Category, Product Subcategory, Sales Amount. (In Excel – check the boxes next to these fields in the PivotTable sidebar.)
  4. Filter the PivotTable on the Country field. (In Excel, drag this field to the Report Filter listbox.)
  5. Format the aggregated Sales Amount column of the PivotTable as currency. (In Excel, right-click on column header, then Format Cells/Currency/OK.)
  6. Save the file.
  7. Open in another implementation.
  8. Refresh/recalculate the Pivot Table. (In Excel, right-click on the Pivot Table, click Refresh.)
  9. Change page filter to show Germany only. The grand total should be 180,826.3758.



ODF File PDF preview

Reopened /modified

ODF File PDF preview


A list of known issues. Implementations not listed here may or may not work as expected. Results may vary depending on user settings and computer environment. Use at your own risk.

Nr Status Write Read Comment
001 Open


scenarios/20091101/pivottable.txt · Last modified: 2010/10/24 18:14 (external edit)
www.ez.nl www.noiv.nl www.opendocsociety.org