I have a financial grid that has a group by on it. I am able to get the footer for each group by to show the appropriate sum of value for the columns i require. What I cant seem to figure out is how do I get a footer to show the sum from each group by group.
eg.
Grouped by Name
Bank Name shares value
Bank 1
Susan 1 $100
Brian 10 $1000
11 $1100
Bank 2
what I want then is another footer here to have the following totals...
22 $2200
So basically I can not figure out how to have a footer apply to all group by's. Any links/code would be appriciated.
Hello,
The closest I see to this scenario in forums is the following forum thread:
http://forums.infragistics.com/forums/p/10716/41011.aspx
Does it provide any clues to get you started?
Thanks Rumen,
Unfortunately this is not workable. What is wanted is basic groupby funciton that Infragistics totally over looked. Why would you offer grouby function with footers for the groupby rows and not a footer that has the grand totals? This is the whole purpose of having groupby footers. They are normally used in calculations.
Not only can you not have this basic function, you cannot set individual groupby footer columns styles in code behind without affecting every footer column in the other groupbys. If I have a negative subtotal in a groupby row for one category and want to make the text red, why the heck should that effect the same column in the other groupby column footers We now have to seek another company who offers these basic functions and thankfully there is a few of them that offer this.