Please note that the RadPivotGrid is a summarization control which is dedicated to data-vizualization, but not modifying the data itself. It rather uses the calculated values from the data fields to build various reports to display and highlight the desired information. It is not suitable for CRUD operations.
I hope the clarification was helpful. Instead, you can check RadGrid with enabled grouping functionality and footer aggregates:
DevCraft Q1'14 is here! Watch the online conference to see how this release solves your top-5 .NET challenges. Watch on demand now.