Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Percent column in Pivot report
Hi,
I have a pivot report based on a query against a database. The query has 3 columns Gender, CntMale, CntFemale In the pivot report, I need to show the percent of Male, for which I believe I need to have the column display the value in the CntMale as a percent of the count of value in column Gender. I have tried various options in the "Value field settings" but cannot figure out how. Appreciate any help ! Thanks, |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Percent column in Pivot report
NetNewbie -
In the PivotTable field dialog box, click on Options then set Show data as: to % of and then choose your Gender column. If this doesn't work, please give us a better clue as to what the data looks like in your pivot table. I am guessing here. -- Daryl S "NetNewbie" wrote: Hi, I have a pivot report based on a query against a database. The query has 3 columns Gender, CntMale, CntFemale In the pivot report, I need to show the percent of Male, for which I believe I need to have the column display the value in the CntMale as a percent of the count of value in column Gender. I have tried various options in the "Value field settings" but cannot figure out how. Appreciate any help ! Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Percent Question | Excel Worksheet Functions | |||
PIVOT TABLES-PERCENT/AMOUNT OF CHANGE | Excel Worksheet Functions | |||
Percent (field1/ field2) on pivot table | Excel Discussion (Misc queries) | |||
Percent of total in Pivot tables | Excel Worksheet Functions | |||
A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) |