Cross Tab Confusion!

[DeviousDi]

Hi All,

I'm hoping someone might be able to point me in the right direction!

I've done a cross-tab to show figures for various depts, similar to this below:

Dept Total 0-30 31-60

A1 31000 7000 24000
B2 25000 2000 23000

GT 56000 9000 47000

Crosstab is looking exactly how I want it. I now need to produce the same crosstab but with percentage instead of figures, so it should look something like this;


Dept Total 0 - 30 31 - 60

A1 100 23% 67%
B2 100 36% 64%

GT 100 16% 84%

I'm grouping on dept, but I've tried alsorts and can't for the life of me get it to work!!

I'm using CR XI SAP

Thanks in advance!

Di