Hi All,
I have 4 groups, namely, Customer Group, Product Group, Country and Sales Rep Name.
I want the grouping to be done , in a way, when the user selects the Customer group as Sort By, the report should be showing results grouped by Customer-Group in Ascending Order. If the user selects ,Product group as the sort by, then result should be sorted and grouped by Product Group Only.

I have been trying using the group sort order formula, but i am not getting the desired result. Now the output is
like Customer Group--> product group--> Country --> Sales Rep Name
its not one group at a time, its grouping and sub grouping. So only the customer group, grouping is coming correctly. Rest of the groups are being repeated multiple times.
Can anyone help me to get my desired output?

Thanks In Advance to all.