Pivot Table support

[glend1]

Pivot Tables is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot table can automatically sort, count total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.

I have found a pretty nice library online that does this, called PivotTable.js but it doesn't let you do anything with the table once you have selected your columns and rows. You cant sort the data.

PivotTable support something they call Renderers. These essentially allow users to replace the table view with a custom function, Their examples show that the user can swap between Graph Types and Tables with ease. It seems unnecessary to rewrite the whole thing so maybe it would be easier if you guys supplied a Renderer to allow us to sort the data once its displayed.

Are there any chances we could see something like this in Tablesorter?

[Mottie]

Hi @doveyg!

That looks like it'll be pretty complex. When I have some free time, I'll look into creating a Renderer. I would be glad for any assistance! ;)

[glend1]

The trouble is I also currently lack free time, ill be sure to update this thread if i can find the time.