There is no Load On Demand for the RadPivotGrid
control and there is no plans for implementing such functionality. We are closely following the Microsoft Excel functionalities where Load On Demand is not supported. The engine that calculates the pivot table requires the full data source in order to correctly display the aggregates and loading partial parts of data is not possible.
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed