Sorting on GrandTotal in PivotGrid.

[Harshal]

Hi Team,

I have implemented the PivotGrid on MVVM silverlight project. I want to sort the Grouping under GrandTotal.
I have shown it (what i want to sort) in attached document with red highlighted mark.

Can anybody please tell if there is any functionality available on PivotGrid or telerik is planning to develop it in future.

your quick response is appreciated.

Thanks. 

[Rosen Vladimirov]

Hello Harshal,

RadPivotGrid can sort the data based on the GrandTotals. You can find more information in our online help. In your case you will have to apply the sorting on the DateTimeGroupDescription:

<pivot:DateTimeGroupDescription PropertyName="Date" Step="Month" SortOrder="Ascending">
    <pivot:DateTimeGroupDescription.GroupComparer>
        <pivot:GrandTotalComparer AggregateIndex="0"/>
    </pivot:DateTimeGroupDescription.GroupComparer>
</pivot:DateTimeGroupDescription>

Please check the mentioned article and inform us in case you have any problems or concerns.

Regards,
Rosen Vladimirov
Telerik