Hi Mustafa,
We would
like to inform you that the values in the Pivot Table are always aggregated
from the entire data source. We cannot retrieve partial records in order to
render the pivot table. Therefore, your requirement is currently not feasible
in our Pivot table component.
However, instead of binding the large records in client
side, we recommend you use our server-side engine support with pivot table.
Because while utilizing server-side engine, the aggregation will be executed in
a different controller project, resulting in a faster execution of pivot table
with aggregation than when using a client-side engine. Using our pivot table
with server-side engine and virtual scrolling or paging support, you can bind
large records with better performance compared to client side engine. Further
UI operations will take less than half the time of the initial rendering.
Please refer to the document link below for more information
on server-side engine support.
Server-side engine:
https://ej2.syncfusion.com/javascript/documentation/pivotview/server-side-pivot-engine
Please let us know if you have any other queries.
With Regards,
Rajeshkannah Gopalakrishnan.
