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%
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%