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 feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.
Thanks again.
Hi Stefan,
Thanks for the solution. I will get back to you if i need further assistance.
Regards,
I am just checking the progress of this issue and was wondering if you managed to achieve your goal or if you need any further assistance on the matter.
Currently there is no build-in functionality for creating hierarchies via the UI of the XamPivotGrid. The thing you can do is creating a custom UI, which you can use to create the hierarchies with code. Please let us know if you have further questions on this matter.
Looking forward for your reply.
Thanks Plamen! That worked.
Just one more question...is it possible to create a complex hierarchy from the front end (without doing an add level in code/xaml)?