I am trying to add a chart to my report. All the 'help' and books I have say formulae can be used but the ones I have do not appear in the list of fields to choose from.
These are percentages based on running total fields, they sit in the group footer and are just numbers. (eg, 100*(total A + total B)/total C)
I am using Crystal 10. Is there any way to get the chart to see these fields, or another way of creating them so it can? (It works ok if I put 'total A' alone, but that is not what is required.)
Also, the only option I have for designing the chart is the Advanced button, despite the fact that I have groups and summaries in the report. I had thought the Group option might be what I wanted, but it isn't available. This does not match what the 'help' says, what is it that makes other options work?
That's two questions I suppose, but they are linked. TIA for any advice.