Skip to Content (Press Enter)
UserImage.jpg
Archit Yadav
52Views
2Comments
[Pivot Table - Traditional] Sorting on Pivot Table extension
Question
Forge
pivot-table
Web icon
Pivot Table - Traditional (O11)
Forge asset by Gonçalo Borrêga

Hi,

I was wondering if I make my pivot tables read only, is there a way to sort by a column within the pivot table?

Regards,

Archit

0
0
07 Nov 2019
Copy Link
2016-11-21 23-23-05
Gonçalo Borrêga

Hi Archit,

Just uploaded a new version that allows sending some extra configurations to the pivot.

Check this example and click the "show more..." in the options of the pivot to view the configuration you'd have to use on the new parameter "RendererOptionsJSON" (available in the new version):

sort: {direction:'desc', column_key:['Conservative']}

This will by default, sort the table (in readonly mode) by the column that is titled "Conservative", in descending order.

There's no way (currently) to block the pivot from allowing the user to then sort it by something else.

Hope this helps



0
0
10 Nov 2019
Copy Link
2020-01-06 05-15-34
Rom_

Gonçalo Borrêga wrote:

Hi Archit,

Just uploaded a new version that allows sending some extra configurations to the pivot.

Check this example and click the "show more..." in the options of the pivot to view the configuration you'd have to use on the new parameter "RendererOptionsJSON" (available in the new version):

sort: {direction:'desc', column_key:['Conservative']}

This will by default, sort the table (in readonly mode) by the column that is titled "Conservative", in descending order.

There's no way (currently) to block the pivot from allowing the user to then sort it by something else.

Hope this helps



Hi Goncalo,

How can I do this in OutSystems 10? Can I modify the eSpace to include this feature? Also, can I sort by Aggregate (eg. Average)?

Please advise.

Regards,

Romuel


0
0
04 Mar 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.