nicolaskruchten / pivottable

Open-source Javascript Pivot Table (aka Pivot Grid, Pivot Chart, Cross-Tab) implementation with drag'n'drop.
https://pivottable.js.org/
MIT License
4.33k stars 1.07k forks source link

Problems with sorting PivotTables #1334

Open jberilo opened 1 year ago

jberilo commented 1 year ago

Good evening everyone.

I'm using the rPivotTable package to create an interactive dashboard with Flexdashboard and Shiny. I created three versions of the same table with aggregations by different attributes. The last two versions refer to the same table, just sorted differently. I'm using the "rowOrder" option to sort the tables. In the first table I used the parameter "key_a_to_z" and it worked. The second table I used "value_a_to_z" to sort by the "Total" column. The third table is the same as the second, only the ordering should be descending. I tried using the "value_z_to_a" parameter but it didn't work. It was the same as the second. Is there a problem or am I doing it wrong?

Regards