Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I manipulate pivot table report to include percentage of?
In my pivot table report, I have two variables in the "data" field, TRIALS
and CONVERSIONS. The two variables are summarized by sums, which is what I want. However, I would like the second variable, CONVERSIONS, to be expressed as a % of TRIALS. What I've tried already: In the Pivot Table Field for the CONVERSIONS variable, I clicked on Options ; I clicked on Show data as "% of". Base field=TRIALS. Here's where the problem is (I think): I don't know what to click on for Base Item; I tried clicking on both (previous) and (next), but I got back a #N/A for the values in the pivot table. How can I get it so that I can show CONVERSIONS as a percentage of TRIALS??? Thanks for the help |
#3
|
|||
|
|||
From the Pivot Table menu, select Formulas. You want to create a calculated
FIELD. The formula is =Conversions/Trials "KRUEMJ-Needs some help" <KRUEMJ-Needs some wrote in message ... In my pivot table report, I have two variables in the "data" field, TRIALS and CONVERSIONS. The two variables are summarized by sums, which is what I want. However, I would like the second variable, CONVERSIONS, to be expressed as a % of TRIALS. What I've tried already: In the Pivot Table Field for the CONVERSIONS variable, I clicked on Options ; I clicked on Show data as "% of". Base field=TRIALS. Here's where the problem is (I think): I don't know what to click on for Base Item; I tried clicking on both (previous) and (next), but I got back a #N/A for the values in the pivot table. How can I get it so that I can show CONVERSIONS as a percentage of TRIALS??? Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
can you use a function to recalc a pivot table report | Excel Worksheet Functions | |||
How do I use multiple worksheets (List) in a Pivot Table Report? | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |