Hi Team,
Need your help in the below issue
Im populating the Pivot data with help of a datatable logic as shown in this link :- http://ko.infragistics.com/community/forums/t/46138.aspx
I want to achieve the SUB TOTALING(yellow col) for the SUB CHILD columns as shown in the image, and the TOTAL (Green col) of the SUB TOTAL(yellow col) columns the way it looks like in image.
Please let me know the possible way to achieve it.
Sincerely,
Pratik Vishwakarma
Hi Petar,
I have achieved the SUBTOTAL and TOTAL columns as required using the DataTable approach only.
Manipulated the data to generate the desired result.
Thanks & Regards,
Pratik
Hello Pratik,
I have been looking into your requirement and even though there is no built-in functionality for extracting data from a DataTable the end result of what you’re looking for seems to be the default behavior. You can see this in the Samples Browser under xamPivotGrid -> Data -> FlatDataSource (Code behind)/(XAML). In the sample you can see a list of items being transformed into pivot data and how hese total columns are modified by altering your HierarchyDescriptors’ LevelDescriptos.
Please let me know, if you require any further clarification on the matter.
Hi Pratik,
I'm currently looking into this. I believe totals are part of hierarchy descriptors that need to be defined on your FlatDataSource but I'm not sure if this will work since you are creating dynamic types and I think the hierarchy descriptors need to know about the class types ahead of time. I'll let you know if it's possible after my investigation.