Pivot table formatting

[chris.dagg]

I followed Owen’s excellent pivot table example and successfully got it to work (thanks for that!). However, minor question, how do I format the pivot table numbers, specifically to be in percentage format?

Here is original post:

Pivot Table Demo

Here’s a demo of an interactive pivot table in an Anvil app: https://WFRNIGNPKB7G6IMG.anvil.app/XMUXHCYB22XZX6OQ65X7RL5J You can clone the app using: https://anvil.works/build#clone:WFRNIGNPKB7G6IMG=QYOAWQL74ZTKPOLVISUJWFGM And here’s a screenshot of how it looks: [11] It uses the PivotTable.js library with the example dataset from that library’s documentation held within Anvil’s Data Tables service (2012 Canadian Members of Parliament). When run, it will throw a deprecation warning mes…

[owen.campbell]

I think this is the relevant page of the docs: Aggregators · nicolaskruchten/pivottable Wiki · GitHub

And that’s not something I’ve built into the integration.

A more complete implementation (probably using the newer methods for handling js) would make a nice contribution to Anvil Extras!

[chris.dagg]

many thanks Owen, appreciate the info!