Values of the level repeating in a hierarchy

[anuhya201]

HI Everyone.

I am currently working on a DMR model REport Studio 8.4. I am having 6 levels in a hierarchy.In the report 3 of my levels are missing.
My report has the following levels in a  hierarchy
Division
Region Group
Sales Office Id
Sales rep
Product Id
Distributor ID.

Many of the sales reps have repeating Product IDs and even Product IDs have repeating distributor Ids. In one of my report I dont need 3 levels i.e Sales Office ID,Sales Rep and Product Id. So I made the report with the following levels from the same hierarchy.
Division
Region Group
Distributor Id.

Wen I am running the report for all values, the output gets me repeated Distributor IDs. I can merge all of them by grouping them. But Its not allowing me to group as it is a cross tab report. Please let me know If I can use any functions to get the grouping done.


Thanks in advance.

Anuhya.