How to display the Overall result value at the top of work book

[Former Member]

Hi,

  How can i display the value of  Overall result(Sum of the Total) column at the top of the work book in Text field.

Thanks

Sreadhar

[Former Member · Accepted solution]

I have just Copied the Sum formula into cell. It is working fine

[former_member182470 · Accepted solution]

Nice to know that..I have never tried..

[former_member182470]

Go to Query Global properties in Query designer and you can find a setting to show result rows on top. This setting will show overall result as first row in the report. But I don't think you can show it in Text field in WB.