Hi,
Is there a way to implement custom value sort on a measure ?
Taking the attached screenshot as an example, I have a xampivotgrid with 2 row fields (no column fields) and a measure. When i sort on measure, i want the sort to happen on the total for the first row field.
i.e Sort should be on the total of measures for A/D/F/G etc... Currently its only picking the first value for the second row field (143/144 etc).
Hope its clear. I can provide more details if required. Basically i need a way to implement custom measure sort.
Thanks
Amit Kamat
Hello Amit,
Thank you for your post. I have been looking into it and I can suggest you see this link from our online documentation:
http://help.infragistics.com/Help/Doc/WPFDV/2011.2/CLR4.0/html/xamPivotGrid_DV_Sorting_Rows_and_Columns.html
where it is explained how to implement a custom sort logic. Please let me know if you have further questions on this matter.
Looking forward for your reply.
Hi Stefan,
I have seen this document and i dont think this is what i need.
The documentation specifies custom sort for Hierarchies/Dimensions and not measures.
How can i sort a measure based on a custom logic ?