sorting

[tgabrielle]

it would be useful to be able to sort the output table columns (A-Z, Z-A) such that the end result is something like 'top 10 provinces who voted NDP' or similar result.

[nicolaskruchten]

Yes, it would be useful, but it's not possible to simultaneously do this and respect the group/subgroup nesting in the row/column headers...

(Duplicate of #44)

[astechdev]

@nicolaskruchten I submitted a PR #369 which enhances the pivot table html table element to be well formed. I was thinking this would then allow that table element to be enhanced with http://datatables.net/ which would then provide all sorts of goodness like sorting, re-ordering, etc. What do you think?

[joankent]

@nicolaskruchten how can I sort the result by the column value? without an aggregator Templates, simply by order direction asc or desc, thanks.

[nicolaskruchten]

@joankent you can't do this at the moment: https://github.com/nicolaskruchten/pivottable/wiki/Frequently-Asked-Questions#sorting-in-built-in-table-renderer

[nicolaskruchten]

I'm closing this issue, as the FAQ addresses it fairly well.