Aggregates and FooterText - I don't get it

[improwise]

Trying to figure out how to use aggregate functions in the footer, but also at the same time having a text of my own choice as well, like "Total sum: XXXX". It seems like there is no way I can combine having a correct formating of XXXX, like {0:N} and having a FooterText, is this right? If I set the DataFormatString, anything in FooterText is ignored, if I clear it, FooterText is displayed but in default format (which seem to be no format). 

How should one do to have both FooterText and control over formating?

[improwise]

Also, if you clear the DataFormatString. it won't affect only the footer as far as I know but anything displayed in the column rows as well. This is just to dumb to be true, it must be me having missed something obvious here??

[Shinu]

Hello Patrik,

The following demo explains the same functionality.
Grid / Footer Aggregates.

Thanks,
Shinu.

[improwise]

Thanks, but I can't see that the demo you link to answers any of my questions or adresses the shortcomings I mention?