Calculation in Sub summary
I'm pretty sure you can't put a calculation in a sub summary, so does anyone know a way that I can work around: My problem is:
I want to report weekly sales, with sub summaries per sales rep and grand total. This all works well but I need to include the the profit margin (which is different on each sale). Profit margin is a calculation (profit/invoice). So while I can use summary fields to total the actual figures, I can't do that will profit margin.
For instance the figures I can not get in my report are highlighted blue:
Can anyone help me create this report with sub summary profit margins?