I have a report which is laid out as follows.
Jan Feb Mar etc
No of Calls 10 11 25
No of Enquiries 11 10 5
Totals 21 21 30
The report has a sub report. The No. of Enquries uses a shared variable to obtain the values from the sub report. The totals adds the shared variable to the formula used to obtain the No of Calls in the main report.
My problem is I want to use the totals figures in a graph, but cant do so because of using a shared variable.
Is there anyway around this