Good day everyone
I have a Sales Report which Group By Branch. I have created a Group on the Report.
On the Group Header: Branch Name attribute with the Condition of Group Prining: Invoice.BranchName; On the Group Footer, I created the attribute <<Sum Invoice.NetAmount>>
When I preview the Report it show as:
Branch A (add up all the invoice is $2000)
On the Group Footer: Total Amount : $2000
Branch B (add up all the invoice is $500)
On the Group Footer: Total Amount : $2500
Why the 2nd Branch did not show $500 instead of add up the 1st Branch total amount together>
Which part I did wrongly?
Please kindly advice... thanks...