Hi Team,
I am trying to use xamPivotGrid to support range columns pivot table. For example, we are running DateTime against Strike pivot table. Rather than showing Strike Spot, I want to show range groups of Strike as below:
1...5 5...10 10...15
01/01/2011
01/01/2012
Is such function supported by xamPivotGrid?
Thanks,
Xin
Hello Xin,
Thank you for posting!
Columns/rows in the XamPivotGrid could be grouped using the hierarchy descriptors. They can help you to build hierarchical structure of your data. It seems that in the following forum thread a similar issue is discussed and Plamen Pilev had provided a solution: http://ko.infragistics.com/community/forums/t/59564.aspx
Please feel free to let me know whether it helps you in resolving your issue.
Hello Maria,
Thanks for your reply!
When creating the hierarchy descriptors, do I need to manually calculate what's the total value for each range or is there any quick way to achieve this?
Hi Xin,
The hierarchy descriptors allow you to create levels and group your data. These levels are defined manually and their displayed values should also be set. If a group of values between 10 and 15 should be created, such descriptor should be added.
If you have any other questions, do not hesitate to ask.