The FOR clause of 'total' must reflect the left to right order of query items

[tarunkrdas2013]

Problem:-I have a DMR report as attached with this thread and when i select Country as United stated from Prompt page the report throws error as

"The FOR clause of 'total' must reflect the left to right order of query items up to and including the item that specifies the control break for the function. "

Any help in this would be highly appreciated

[tarunkrdas2013]

Thank you ,this issue got solved by changing expression from total ([Daily Refunds] for [Major Department]) to total ([Daily Refunds] within set [Major Department])