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://es.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
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 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