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
|
|||
|
|||
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
|
|||
|
|||
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, |
Thread Tools | |
Display Modes | |
|
|