exporting Tables and Pivot Tables that have been modified by a script

Hello: I've been exploring a few ways to modify values contained in Table and Pivot Table widgets using the script editor. While I have successfully been able to modify the widget in my browser, when I export the data to CSV or Excel, I'm still getting the original/underlying values from the data model. Is there any way to get around this?

-Ben

bminehart

Posted 1 year ago·Last reply 1 year ago

3 comments

jacobd

·1 year ago

I'm having the same issue. I just want the ability to build a percent difference between two pivoted columns. I'm guessing that you are trying to do something similar. I've been using JS to do this, but a client wants to export to excel. If Javascript doesn't load while exporting to Excel is there a Sisense function built in that could be used to pull in two different values from different columns to make calculations?