Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating Calculations Within a Field
Hello,
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. I greatly appreciate any help. Thanks! Minh |
#2
|
|||
|
|||
Hi
assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
#3
|
|||
|
|||
I should have mentioned that I am working with a pivot table. Is it possible
to create a formula within a field? 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. I greatly appreciate any help. Thanks! Minh "JulieD" wrote: Hi assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
#4
|
|||
|
|||
Hi
you can add calculated fields to pivot tables, on the pivot table toolbar, click on the pivot table icon and choose formula ... see how you go. Cheers JulieD "MinhPhan" wrote in message ... I should have mentioned that I am working with a pivot table. Is it possible to create a formula within a field? 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. I greatly appreciate any help. Thanks! Minh "JulieD" wrote: Hi assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
#5
|
|||
|
|||
I could see how I would calculate between various fields, but I could not set
up a calculation within the field itself. Did I overlook something? I am also trying to group the values, but it does not allow for subtraction (only summing). "JulieD" wrote: Hi you can add calculated fields to pivot tables, on the pivot table toolbar, click on the pivot table icon and choose formula ... see how you go. Cheers JulieD "MinhPhan" wrote in message ... I should have mentioned that I am working with a pivot table. Is it possible to create a formula within a field? 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. I greatly appreciate any help. Thanks! Minh "JulieD" wrote: Hi assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
#6
|
|||
|
|||
Hi
can you post a 5 line example of the data that the pivot table is based on .... please don't attach a workbook just type it out the format .......A........B.............C..............D 1....data...data........data..........data thanks - as i'ld like to try out a few ideas Cheers JulieD "MinhPhan" wrote in message ... I could see how I would calculate between various fields, but I could not set up a calculation within the field itself. Did I overlook something? I am also trying to group the values, but it does not allow for subtraction (only summing). "JulieD" wrote: Hi you can add calculated fields to pivot tables, on the pivot table toolbar, click on the pivot table icon and choose formula ... see how you go. Cheers JulieD "MinhPhan" wrote in message ... I should have mentioned that I am working with a pivot table. Is it possible to create a formula within a field? 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. I greatly appreciate any help. Thanks! Minh "JulieD" wrote: Hi assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
#7
|
|||
|
|||
Here is an example of the data:
Name Activity Time Jason Walking 0:30:00 Jason Running 0:15:00 Jason Dumbels 0:18:00 Jason Bench 0:13:00 Mark Walking 0:30:00 Mark Running 0:15:00 Mark Dumbels 0:18:00 Mark Bench 0:13:00 In the pivot table, I would like to add a new activity and it is Walking minus Running. The pivot table will then be: Activity Total Bench 0:26:00 Dumbels 0:36:00 Running 0:30:00 Walking 1:00:00 Walking - Running 0:30:00 Thanks for looking into this! "JulieD" wrote: Hi can you post a 5 line example of the data that the pivot table is based on .... please don't attach a workbook just type it out the format .......A........B.............C..............D 1....data...data........data..........data thanks - as i'ld like to try out a few ideas Cheers JulieD "MinhPhan" wrote in message ... I could see how I would calculate between various fields, but I could not set up a calculation within the field itself. Did I overlook something? I am also trying to group the values, but it does not allow for subtraction (only summing). "JulieD" wrote: Hi you can add calculated fields to pivot tables, on the pivot table toolbar, click on the pivot table icon and choose formula ... see how you go. Cheers JulieD "MinhPhan" wrote in message ... I should have mentioned that I am working with a pivot table. Is it possible to create a formula within a field? 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. I greatly appreciate any help. Thanks! Minh "JulieD" wrote: Hi assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
#8
|
|||
|
|||
Hi
i was able to achieve this: 1) click on "bench" in the pivot table 2) choose pivot table (icon on the toolbar) 3) choose formulas 4) choose CALCULATED ITEM 5) called it WR 6) typed the formula = Walking - Running and clicked on OK Cheers JulieD PS i'm using Ver 2003 not sure when this option was made available (never done it before) "MinhPhan" wrote in message ... Here is an example of the data: Name Activity Time Jason Walking 0:30:00 Jason Running 0:15:00 Jason Dumbels 0:18:00 Jason Bench 0:13:00 Mark Walking 0:30:00 Mark Running 0:15:00 Mark Dumbels 0:18:00 Mark Bench 0:13:00 In the pivot table, I would like to add a new activity and it is Walking minus Running. The pivot table will then be: Activity Total Bench 0:26:00 Dumbels 0:36:00 Running 0:30:00 Walking 1:00:00 Walking - Running 0:30:00 Thanks for looking into this! "JulieD" wrote: Hi can you post a 5 line example of the data that the pivot table is based on .... please don't attach a workbook just type it out the format .......A........B.............C..............D 1....data...data........data..........data thanks - as i'ld like to try out a few ideas Cheers JulieD "MinhPhan" wrote in message ... I could see how I would calculate between various fields, but I could not set up a calculation within the field itself. Did I overlook something? I am also trying to group the values, but it does not allow for subtraction (only summing). "JulieD" wrote: Hi you can add calculated fields to pivot tables, on the pivot table toolbar, click on the pivot table icon and choose formula ... see how you go. Cheers JulieD "MinhPhan" wrote in message ... I should have mentioned that I am working with a pivot table. Is it possible to create a formula within a field? 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. I greatly appreciate any help. Thanks! Minh "JulieD" wrote: Hi assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
#9
|
|||
|
|||
Thanks Julie! This is exactly what I needed!
Minh "JulieD" wrote: Hi i was able to achieve this: 1) click on "bench" in the pivot table 2) choose pivot table (icon on the toolbar) 3) choose formulas 4) choose CALCULATED ITEM 5) called it WR 6) typed the formula = Walking - Running and clicked on OK Cheers JulieD PS i'm using Ver 2003 not sure when this option was made available (never done it before) "MinhPhan" wrote in message ... Here is an example of the data: Name Activity Time Jason Walking 0:30:00 Jason Running 0:15:00 Jason Dumbels 0:18:00 Jason Bench 0:13:00 Mark Walking 0:30:00 Mark Running 0:15:00 Mark Dumbels 0:18:00 Mark Bench 0:13:00 In the pivot table, I would like to add a new activity and it is Walking minus Running. The pivot table will then be: Activity Total Bench 0:26:00 Dumbels 0:36:00 Running 0:30:00 Walking 1:00:00 Walking - Running 0:30:00 Thanks for looking into this! "JulieD" wrote: Hi can you post a 5 line example of the data that the pivot table is based on .... please don't attach a workbook just type it out the format .......A........B.............C..............D 1....data...data........data..........data thanks - as i'ld like to try out a few ideas Cheers JulieD "MinhPhan" wrote in message ... I could see how I would calculate between various fields, but I could not set up a calculation within the field itself. Did I overlook something? I am also trying to group the values, but it does not allow for subtraction (only summing). "JulieD" wrote: Hi you can add calculated fields to pivot tables, on the pivot table toolbar, click on the pivot table icon and choose formula ... see how you go. Cheers JulieD "MinhPhan" wrote in message ... I should have mentioned that I am working with a pivot table. Is it possible to create a formula within a field? 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. I greatly appreciate any help. Thanks! Minh "JulieD" wrote: Hi assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
#10
|
|||
|
|||
you're welcome and thanks for the feedback
"MinhPhan" wrote in message ... Thanks Julie! This is exactly what I needed! Minh "JulieD" wrote: Hi i was able to achieve this: 1) click on "bench" in the pivot table 2) choose pivot table (icon on the toolbar) 3) choose formulas 4) choose CALCULATED ITEM 5) called it WR 6) typed the formula = Walking - Running and clicked on OK Cheers JulieD PS i'm using Ver 2003 not sure when this option was made available (never done it before) "MinhPhan" wrote in message ... Here is an example of the data: Name Activity Time Jason Walking 0:30:00 Jason Running 0:15:00 Jason Dumbels 0:18:00 Jason Bench 0:13:00 Mark Walking 0:30:00 Mark Running 0:15:00 Mark Dumbels 0:18:00 Mark Bench 0:13:00 In the pivot table, I would like to add a new activity and it is Walking minus Running. The pivot table will then be: Activity Total Bench 0:26:00 Dumbels 0:36:00 Running 0:30:00 Walking 1:00:00 Walking - Running 0:30:00 Thanks for looking into this! "JulieD" wrote: Hi can you post a 5 line example of the data that the pivot table is based on .... please don't attach a workbook just type it out the format .......A........B.............C..............D 1....data...data........data..........data thanks - as i'ld like to try out a few ideas Cheers JulieD "MinhPhan" wrote in message ... I could see how I would calculate between various fields, but I could not set up a calculation within the field itself. Did I overlook something? I am also trying to group the values, but it does not allow for subtraction (only summing). "JulieD" wrote: Hi you can add calculated fields to pivot tables, on the pivot table toolbar, click on the pivot table icon and choose formula ... see how you go. Cheers JulieD "MinhPhan" wrote in message ... I should have mentioned that I am working with a pivot table. Is it possible to create a formula within a field? 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. I greatly appreciate any help. Thanks! Minh "JulieD" wrote: Hi assume your example is in cells A1:B4 the formula you're looking for is B4-B2 Cheers JulieD "MinhPhan" wrote in message ... Hello, 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. I greatly appreciate any help. Thanks! Minh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions | |||
Creating Spreadsheet Calculations | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Creating a new field | Excel Discussion (Misc queries) |