I have a XamPivotGrid, which contains drilldown, on the first level I need to choose the records for summary depending on a value in a particular field with the records of the lower levels. So that if I have 3 levels below the first level, the value 3 have a hundred I could show 200 as the sum on the first level and a field I would indicate that one of the three should not be to summarize, how could I do that?
Hello,
Thank you for your post. I have been looking into it and I suggest you use custom aggregators to achieve your goal. Here it is described step by step how to do so:
http://help.infragistics.com/NetAdvantage/WPFDV/2011.2/CLR4.0/?page=xamPivotGrid_US_CustomAggregators.html
Also here it is a sample in Silverlight that demonstrates this:
http://samples.infragistics.com/sldv/RunSamples.aspx?cn=pivot-grid#/pivot-grid/flatdata-aggregators
and since the XamPivotGrid is a cross-platform control you can use it.
Hope this helps you.