How to handle 50k data with Pivot table, I am facing lag struck issue with 50k data.
Hello @suman2020 ,
50k elements is not a big dataset. However, it all depends on how many operations are inside the pivot. For example, if you have a couple of hundred columns with some complicated math operations then most likely it is impossible to speed up the processing of this data (on the client).
Could you please share your pivot structure and the data that you load?
The only solution is to process the data on the server:
- all calculations can be done using some script on the server, and simply load the grouped data and structure settings into the pivot. Then it will look and work the same way, just there will be no calculations on the client side. This feature is called external data processing. So it frees the client part from the load in the calculations.