Creating Calculations Within a Pivot Table Field

M

MinhPhan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Calculations Within a Field 4
Dealing with a Pivot Table (when I don't want to) 0
Creating a Timeline 0
Finding the proper style field and the numbered paragraph value within the style 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Variance 2
Formula to Look up values from a pivot table 1

Top