Each column is a combination of three fields: a chief, an employee and a category.Drag and drop " Total" and " Sales" into the area " Data fields".Drag and drop " Date" and " Cb" into the area " Row fields".Drag and drop " Chief", " Employee" and " Category" into the area " Column fields".Drag and drop " Region" into the area " Page fields".Keep the default setting " Current selection", and click " OK".Click on " Data" > " Pivot table." > " Create.".You should select 307 lines and 9 columns. Select all the lines and columns that appear on the document named "sheet1".
It is not as complete as Microsoft's spreadsheet, but it is more than adequate to start with.
Please note that I use Open Office Calc (4.1.2) since this spreadsheet is free. The content of the file " data.csv", that will be loaded into the spreadsheet, looks something like: Date Total Sales Cb Check Category Region Employee Chief Please note that this image has been generated with the DBVIEW utility, which can be downloaded here. The figure below represents the database's structure (given in the SQL file " model.sql"). The file " data.ods" contains the spreadsheet's document.The file " model.sql" contains the model of the MySql database use to store the data.The file " data.sql" contains the data, and it can be loaded into a MySql database.The file " data.csv" contains the data, and it can be loaded into the spreadsheet.The result of the script's execution are the files " data.csv" and " data.sql". The script " " is used to generate the sample data.The previously given link points to a document that contains the following files: You can find this script here, along with the generated data. First of all, I began to create a script that generates sample data.
0 kommentar(er)
