Query Designer

Hi,

I have to build a query in QD 7.0 which schould cotain the Countries (Hierarchy) in the Rowes and Revenue % in the Columns.

I have to show the revenue% in three catagory: >30%, 10-30% and <10% with sum for each catagory, somehow like this:

Greater than 30%

usa 40%

can 31%

.

.

sum

Between 10-30%

IT 20%

CA 21%

.

.

sum

Less than 10%

DE 9%

FR 8%

.

.

sum

Total sum

can any one tell me how to do it. I tried with conditions but it does'nt work.

Thanks for any help in advance