Table widget - Include Pivot functionality

[MarkWILSON_LLS]

I'd love to see an enhanced Table widget that allows for pivot table functionality in ExB which could be used to provide complete summaries of sites in a simple pivot table rather than having to export raw data to csv and undertaking the Pivot in Excel. 

Functionality would be similar to Excel Pivot Table :

Row, Column and Values Fields should all be able to be defined from the table being used

Filters would ideally have an ability to link to other filters enabled on the ExB site (Filter Widget or Map Filters)

Refresh timeframes for data updates to be defined in the setup

Ideally - Data would allow for integration of Parent and Related tables but this can be offset if needed by using a joined View. 

thanks

mw

[Katie_Macintyre_Atmos]

This would be really useful. We often have to summarise data by multiple fields and the only way to do it currently is to export the csv to excel, or filter the data to look at one category at once. It would be a much better dashboard style experience to be able to view the summary straight in the EB app.