S
Sienna
Eight (8) columns of data is pulled into an Access pivot table from Excel.
The data is categorized by programs. Each program has rows representing
error codes, total number of orders, critical errors, ancillary errors, total
errors and percent of errors. The percent of errors in each row is
calculated properly (total errors/total orders). My problem is in the grand
total of the percent of errors. The grand total sums the column instead of
showing the grand total percent of errors derived from the grand total of
orders.
The data is categorized by programs. Each program has rows representing
error codes, total number of orders, critical errors, ancillary errors, total
errors and percent of errors. The percent of errors in each row is
calculated properly (total errors/total orders). My problem is in the grand
total of the percent of errors. The grand total sums the column instead of
showing the grand total percent of errors derived from the grand total of
orders.