CROSSTAB COLUMN PROBLEM

[zahid999]

Dear Friend,

I am getting Report Like this:

MTH1 MTH2 TOTAL

CTG01 111 150 250
10% 15% 14%
CTG02 222 222 444
20% 22% 20%

Total TTT TTT TTT
pp% pp% pp%
---------------------------------------------

MY OBJECTIVE to create CrossTab report is like below.

MTH1 MTH2 TOTAL
AMount % Amount % Amount %
CTG01 111 10% 150 15% 250 14%
CTG02 222 20% 222 22% 444 20%

Total TTT pp% TTT pp% TTT pp%

could some one guide how to create column and text object.

Kind Regards,
Zahi

 

[synapsevampire]

You'll need to build a manual cross-tab for that exact output I think.

This means manually building each calculation using aggregate functions such as SUM()

-k