UNFINISHED/WORK IN PROGRESS
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.
Open data.ods (sample data file with 5000 rows)
Insert a Pivot Table (data pilot) on a new worksheet, based on the entire range of the data. (In Excel – Insert/PivotTable/OK.)
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.)
Filter the PivotTable on the Country field. (In Excel, drag this field to the Report Filter listbox.)
Format the aggregated Sales Amount column of the PivotTable as currency. (In Excel, right-click on column header, then Format Cells/Currency/OK.)
Save the file.
Open in another implementation.
Refresh/recalculate the Pivot Table. (In Excel, right-click on the Pivot Table, click Refresh.)
Change page filter to show Germany only. The grand total should be 180,826.3758.
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 || || ||