| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Creating Calculations Within a Pivot Table Field
Hello,
In my pivot table, I have an Activity field with various activities and I would like to calculate the time values between these activities. For example: Activity (Field) Time (Avg) Stand 12:00 Run 13:00 Stop 13:30 I would like to add a calculation within Activity that is Stop - Stand. Is this possible? I have been able to create calculations between various fields but not within a field. I need to use a pivot table because it is a survey with a great deal of data and I will be slicing and dicing this data. I greatly appreciate any help. Thanks! Minh |
| 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 Problems | Excel Discussion (Misc queries) | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
| Calculated Field in Pivot Table | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
