Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Percentage in Crosstab, Total Row Only

Status
Not open for further replies.

VWoody12

Programmer
May 26, 2016
1
US
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%
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top