Multiple Totals Columns in a Pivot Table
There is a method for generating multiple values but it looks at only the
values related to the current Column Heading. For instance if you wanted both
a count and sum for the current Column and Row.
It looks like you want to divide a single column value by a total of all
columns to get a percent.
Have you considered creating a report that divides the status count by the
total count?
--
Duane Hookom
Microsoft Access MVP
"Danny" wrote:
Hi.
I've built a pivot table, and get totals values displayed as expected. In
this case, it's a count of records.
But I also want to see values for several expressions involving select
categories. For example:
Status
______
Location | Total Number of Records | Total of Status1 / Total
Number of Records
Is this possible?
Thanks.
Danny
|