Yes, it's possible to use WCF RIA with RadPivotGrid. I'm sending you a simple project demonstrating such solution. Please note that RadPivotGrid has only CTP version and its functionality will be extended in the near future. You may find some issues while using it and in such cases please inform us and we'll try to solve the problem at our earliest.
Please check the attachment and inform us if you have any concerns.