Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculated field in Pivot Table
I am having problems with a calculated field in a pivot table.
I believe the challenge is the in the way pivot tables summarizes then multiplies. For example 10/1/05 task 1 = 2.00 hours 10/1/05 task 2 = 3.00 hours 10/3/05t task 3 = .50 rate 50.00/hour thus, as it is occuring now (2.00+3.00+.50=5.5 * 50.00) * 3 Instead what i am looking for in the above example is 5.5 hours *50.00/hr. Any idea, how i can accomplish this? thanks Jerry |
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 | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | 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) |