Add Percentage to CrossTab

[craigalaniz]

Hi All

I am trying to add a column to calculate a percentage to a crosstab. I have a list of categories and I use COUNT() the total number of each. I also have the total of all. I can't seem to get calculate the percentage. I have tried COUNT(Category)\Total().

Example cross tab

           COUNT       %
Cat1 - 382          382/645       
Cat2 - 169          169/645
Cat3 - 94              94/645

Total  - 645

Thanks

Craig

[MFGF]

Hi All

I am trying to add a column to calculate a percentage to a crosstab. I have a list of categories and I use COUNT() the total number of each. I also have the total of all. I can't seem to get calculate the percentage. I have tried COUNT(Category)\Total().

Example cross tab

           COUNT       %
Cat1 - 382          382/645       
Cat2 - 169          169/645
Cat3 - 94              94/645

Total  - 645

Thanks

Craig

Hi,

Are you using a relational or dimensional package for this report?

MF.

[craigalaniz]

Hello

I am using a relational package.

Thanks

Craig

[bi4u2]

Craig, sometimes when working with crosstabs you need to experiment with the property called 'Solve Order', make the solve order on the percentage calculation a 2 or 3 and see what happens.