If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Totals Columns in a Pivot Table
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Multiple Totals Columns in a Pivot Table
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|