Multiple Totals Columns in a Pivot Table
You could possibly pass in the "a specific column" to the query to create a
Row Heading with your calculated value.
--
Duane Hookom
MS Access MVP
"Danny" wrote in message
...
Hi Duane.
You're exactly right - I want to divide a specific column total by the
Grand
Total. A report would be ok, except I want the user to be able to change
the
Group By columns on the fly - which a pivot table would allow, wouldn't
it?
Can I base a pivot table on a crosstab query where I would have those
expressions as calculated fields?
"Duane Hookom" wrote:
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
|