In order for a file to be loaded correctly you require a comma delimited CSV File with the first row containing the column headers.


Each row seperated by a carriage return line feed.

Okay, if this is still not clear then check out the image below.




Please ensure no data columns contain a comma. ie 9 columns will require 8 commas as per example

Size being 262 oz and NOT 262,oz for example


This is an option that will allow you to filter the data for the pivot table. Enter your search patterns seperated by spaces.

Be sensible with the number of rows in the csv file for the datatable as it is all rendered to a table with paging.


For more infomation click About in the navigation bar above.


Click to Continue   Not sure how it works - Watch the Video

Data Constructed

Transfer the Data to the Pivot Table - Confirmation Required


Not sure about the Pivot Table/Graphing - See the video

Processing File

Please wait .......

×

About

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.

Your File

You can load your own file into the pivot table. Note: Your information does not leave the browser ie. it is NOT copied elsewhere. Performance is at the speed of your computers memory and the amount of data that can be loaded is dependant on free available memory. That said, do not go crazy with the amount of columns imported. Do not load column that are not required, it will slow the load process and use more memory, especially with large files.

Presentation

Drag and drop with filtering, totalling, calculations etc. Graph the displayed data with subsequent graph modifications and data export options.

For the Developer

You can add derived and calculated columns, in script, between loading and displaying the data. For exampe you could split dates into years, quarters, months etc and initally open with preselected totalled rows and columns. You can even add entries to the list of drop down options.

Credits

A significant amount of code is required to essentialy link the compnents together. However it would not be possible without the Krutchen Pivot Table - you will find this on Github. Links on my credits page.

➤