zonemaster88
New Member
- Joined
- Sep 15, 2014
- Messages
- 3
Hi, I am trying to get the average cost of items with duplicates of the same item but having different value in a pivot table. I tried looking for an answer on here and was unable to find one.
Ex:
<colgroup><col span="2"></colgroup><tbody>
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
</tbody>
A pivot table would get the average of $408 when I sort by date. However, the average I am looking for is of all the orders with 5135 combined. This would be $476. I understand that I could just sort this by item # but the actual data I'm working with has over 80,000 items (in-practical). Anyone know how to combine item numbers and get the average of combined like items in a pivot table?
Thanks!
Ex:
<colgroup><col span="2"></colgroup><tbody>
Date | Item # | Value |
1-Sep | 1594 | $100 |
1-Sep | 5135 | $75 |
1-Sep | 5461 | $985 |
2-Aug | 7484 | $356 |
6-Apr | 8789 | $125 |
15-Jul | 5135 | $502 |
28-Feb | 1289 | $714 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
A pivot table would get the average of $408 when I sort by date. However, the average I am looking for is of all the orders with 5135 combined. This would be $476. I understand that I could just sort this by item # but the actual data I'm working with has over 80,000 items (in-practical). Anyone know how to combine item numbers and get the average of combined like items in a pivot table?
Thanks!