I have a view in my list,
I defined aggregations in my view: sum and average of several columns.
Now I want to get programmatically the aggregations results.
How can I get it?
The aggregation is not something that is calculated and stored but just defined type of aggregation required or to be done.
You need to calculate it your own. SharePoint displays the aggregated data by using XSLT.
-
Do you know how SharePoint perform this calculation? (And where to find it) – banana Aug 19 '13 at 14:39
-
As I told you, since SharePoint uses XSLT so doing aggregation calculation using XSLT. XSLT is used to define how XML is to be rendered and formatted, like CSS for XHTML/HTML. I also required to do the calculation but ended up with calculating my own way in by enumerating through each list item. – Amit Bhagat Aug 20 '13 at 2:36
-
-
No I am not sure, you need to do some research on that, you can search on google or post a questions on same. – Amit Bhagat Aug 20 '13 at 5:35
I had similar case and I wasn't find solution for getting grouped result from list view. I write custom code on c# and LINQ with all aggregation and render data on third-party grid component.