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?
How should one do to have both FooterText and control over formating?