Can you please share an example snippet for a pivot table with pagination in it.
In my scenario, i have rows around 500,000 in pivot and export to export doesn’t support those many rows to export.So i hope, pagination would help in this case.
So can anyone please help out with this ?
Hello @sangeetha,
In my scenario, i have rows around 500,000 in pivot and export to export doesn’t support those many rows to export.So i hope, pagination would help in this case.
While it is fairly straightforward to provide a pager for a component, this does not seem to solve the original issue you are having. Nevertheless, here is an example of how you can add one: https://snippet.webix.com/4xy8smdj.
As for the original issue, the only feasible solution that I can suggest would be to manually filter out a number of rows. This can be done by providing a custom filtering function inside of the export options. Here is an example: https://snippet.webix.com/xtec4c4i.
You can see all of the available export options in our documentation.
Thanks for the response @Dzmitry
Another question is since the number rows for the pivot table is around 500k and the number of columns are around 18. Because of which the screen hangs if we scroll up/down or search in search box is populating slow… For this webixworker hold good… but what code implementation need to added to webixworkerstart and end to see the smooth scroll down and up?
can u guide me with this?