Unfortunately, the desired could not be achieved with the current implementation of the control and there isn't any alternative that we could suggest you. RadPivotGrid
constructs the filtering queries that are passed to the OLAP cube by itself and the returned result is processed by the control and then visualized. You could create a separate query to the OLAP cube in order to extract the result, but won't be able to visualize it inside RadPivotGrid
Hope this helps.
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.