| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you divide two cells in a pivot table to equal a %?
I have taken my data from one spreadsheet and created a pivot table. That
table has four columns with 26 lines. I want to divide one cell by another with a formual and copy the formula. Total dollars paid dollars chargedback that month ongoing chargebacks. I want to divide line 2 by line one. Divide line 3 by line one. I then have the same scenerior for 15 more areas with the same three lines and different dollars. What is the formula that I can copy. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to stop cells from adding together on a pivot table? | Excel Discussion (Misc queries) | |||
| Merged cells and Pivot table | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
