Add additional Summary to Sales Report Summary
Sorry I'm late to the party.
@nheuer, can you attach the latest .rpx file with the incorrect totals? Maybe something will jump out.
@michael-hansen, thanks for all the great suggestions here.
Hi to all! Hope everything is well with you. In my case I did a grouping by Salesperson. So I need to have totals for each salesperson and then the grand total at the end of the report. It seems to work well with the standard fields, however variables don't behave the same way. While standard fields sum correctly, the variables (for example the $Tax variable) ends up adding the first salesperson tax to the second salesperson tax. Same happens for $discount.
However the $Records just bring up the amount of records of the last salesperson. I do not know if hte problem are the variables or the grouping. I am attaching my .rpx to see if anyone can help me to understand and correct this issue. Thanks in advance for your replies!
It Worked like a Charm! Thanks for your time!