On a side note, you could take a look at the RadPivotGrid's Custom Data Calculations help article and see if you could implement any custom logic that could allow you to get the desired result.
Regards,
Konstantin Dikov
Telerik
DevCraft Q1'14 is here! Join the free online conference to see how this release solves your top-5 .NET challenges.Reserve your seat now!