Total Count\value to show in another query

[cbyrne]

Hello i have a list report with totals for certain columns but i need to show one of these totals in another part of the report in a table below the list or in another query\tab, is this possible as i have tried all sorts of ways and i keep getting a 0 value although there is a value in the total column.


Many Thanks

Chris

[blom0344]

Did you try a singleton?

[cbyrne]

Hi Yes i did this but in the end i found the solution in the below data item.


total([Dataitem] for report)

it was as simple as that so now i can total in a table below the page.  Not sure how you would get this into another page tab though, i will have to work on this. 

Thanks

Chris