Analytics Software

Hi all,

I am using obiee 11g.

My report columns are year,company(company hierarchy-> detail level),project group, project subgroup,project number(project hierarchy-> detail level) and revenue.

And i have kept project group and project subgroup sub totals.

While selecting two project groups in prompt the report displaying subtotals for the project group and project subgroup but project number wise order.

For example XXXX - project group has aaa,bbb,ccc project subgroups.

and YYYY - project group has ddd,eee,fff project subgroups.

But the project numbers in that groups are different.

My requirement is i have to display subtotals based on project group and subgroup if that project numbers are not in the order.

Thanks in advance.

Guide me regarding this.