This content has been marked as final. Show 2 replies
Again, as I got no help from the forum, I resolved this by changing the data model within BI Publisher and created another query for the summary data and then referenced this on the other page.
Will leave thread open for a few days in case someone has a better way of doing it.
I wanted to reference the existing data because:
a) it is already there, why should I have to run another query
b) I am guaranteed to get the same results and won't have any rounding type issues when aggregating the individual values.
Don't know if there are any Excel template/Bi Publisher developers out there but it initially appears to me that if you are doing anything a little clever you are on your own.
When I mean clever, I mean do more than just publish data directly, unformatted, unchecked or unmanipulated from the xml by creating sub totals and totals, additional functions both row and group level then it may be possible but you have to find out on your own.
Surprise, surprise, No replies so closing thread.