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
Quote from: craigalaniz on 12 Dec 2014 04:17:49 PM
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.
Hello
I am using a relational package.
Thanks
Craig
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.