Show Pivot from Webix Spreadsheet data

Is there a way where we can show data in a spreadsheet, edit the data and then based on this data, we can show the pivot table?

Hi, @zihad !
You can create function which will transform spreadsheet data into data for pivot table.
Please, check the snippet for version 9.0, 9.1- Code Snippet
Example for webix versions 8.2-8.4: Code Snippet
To make them work select cells A2:E7 and click the “Summary table” button