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

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

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

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" <Danny@discussions.microsoft.com> wrote in message 
news:AB84BB42-7E64-4C3C-89AB-078122950936@microsoft.com...
> 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