Ability to create a pivot table in wpDataTables#541

Since pivot tables can be tricky to work with, would love the ability to create a pivot table within wpDataTables. I use Google Sheets and have a lot of data in pivot tables that I want to displayon my site. The pivot tables allow for automatic updates when new data is added to the original spreadsheet, but wpDataTables doesn’t play well with pivot tables in many cases. The ability to create one within wpDataTables directly to pivot the original data would be a HUGE help

Hello DX Central,

Thank you for your suggestion. Currently, wpDataTables does not have a built-in option to create pivot tables. Additionally, importing a Google Sheets table that contains a pivot table can cause issues, as our logic requires tables to have proper headers.

As a workaround, you can add an extra row above the pivot table and manually define column headers. After doing this, you should be able to import the pivot table successfully. While this is not a perfect solution, it might help in your case. Please check the images below for reference.

We appreciate your feedback and will consider your suggestion for future updates.