Greetings

I am new to the forum and have recently started using Webfocus for producing management information reports. I am using Webfocus Version 769 running on Windows XP.

What I am getting is a percentage for the numbers produced like so:

Type A Type B Total
Column 1 Column 2 Column 1 Column 2
Number Percentage Number Percentage Number Percentage
A 20 20 50 50 70 70
B 80 80 50 50 130 130
Total 100 100 100 100 200 200

So what is happening is that the Total Percentage is being calculated by adding all the columns together rather than recalculating the percentage on the total figure.

How would I get from here to the following?

Type A Type B Total
Column 1 Column 2 Column 1 Column 2
Number Percentage Number Percentage Number Percentage
A 20 20 50 50 70 35
B 80 80 50 50 130 65
Total 100 100 100 100 200 100

Code:
TABLE FILE BANDSPERFORMANCE
SUM
'CNT.BANDSPERFORMANCE.BANDSPERFORMANCE.INSTITUTION_ID'
'PCT.CNT.BANDSPERFORMANCE.BANDSPERFORMANCE.INSTITUTION_ID'
BY 'BANDSPERFORMANCE.BANDSPERFORMANCE.RETENTION'
ACROSS 'BANDSPERFORMANCE.BANDSPERFORMANCE.SBTYPE'

I hope that this is clear. Many thanks for any help you can give me.

This message has been edited. Last edited by: Kerry,

Hi dmusi,

This may not be exactly what you need, but it may help with getting you start:

http://forums.informationbuild...761085132#7761085132

HTH,

Kerry