| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Compunding Return instead of Adding it?
I have a table with daily return. I need to get the compound interest
or return for every month using a pivot table of excel. What I need is to add 1 to the every return and multiply the result grouping an entire month and then to reduce 1 again. how can I do it in a pivot table?? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding average to pivot table | Excel Discussion (Misc queries) | |||
| pivot table | Excel Discussion (Misc queries) | |||
| pivot table | Excel Discussion (Misc queries) | |||
| pivot table | Excel Worksheet Functions | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Linear Mode
