Cross-Tab question

[sasa888]

Hi all, is it possible to show the % of a field at 'Row Level' using 'Row' and Grand Total of a field using 'Column' to calculate the percentage? Please see my example below. Thank You!


Column1 Column1% Column2 Column2% Grand Total %
Row1 1 6% 2 9% 3 8%
Row2 5 31% 2 9% 7 18%
Row3 10 63% 8 36% 18 47%
Row4 0 0% 10 45% 10 26%
Total 16 42% 22 58% 38 100%

 

[lbass]

What version of CR are you using?

-LB

 

[sasa888]

CE10

 

[lbass]

Create a formula {@grtot}:

{table.amt} % sum({table.amt})

Add this as a summary field, using sum as the summary. This works in 11.0. You might have to select the cells and totals in preview and click on the % icon.

-LB