In this thread (thread767-1619236) it discusses how to create a percentage as the last column in the crosstab, can this also be performed as a percentage below (or with) the Total row? How should the code be modified to have the percentage for each column be based on the Total for that column divided by the grand total.
In the example below, Emp1: 11/27=40.74 & Emp2: 16/27=59.26:
Date: Emp1: Emp2: Total:
1/1/2016 5 7 12
1/2/2016 6 9 15
Total: 11 16 27
Percent: 40.74% 59.26%
In the example below, Emp1: 11/27=40.74 & Emp2: 16/27=59.26:
Date: Emp1: Emp2: Total:
1/1/2016 5 7 12
1/2/2016 6 9 15
Total: 11 16 27
Percent: 40.74% 59.26%