Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Excel report pivot table
-
Does anyone happen to have any experience with excel reports on the mango and putting pivot tables into the reports? Just curious if there's any way to have the mango kick the pivot table into updating itself after the export of data is complete.
Thanks
-
Hi psysak,
I admit to having just tried to learn about pivot tables. It seems to me that if your pivot table were defined in terms of the named ranges, it should work. But, I attempted this with Google sheets and discovered one cannot tie a pivot table to a named range.
If this is what you have tried (which, I actually think Excel would do automatically), then it's probably not possible. Looking into the documentation for Apache POI, I didn't see anything that suggested a notion of recomputing, only defining again. While it is possible in Apache POI to define a pivot table, the relevant configuration is not offered through Mango and so this would be somewhat of a feat to achieve, currently.