![]() |
|
#1
|
|||
|
|||
![]()
I don't have Excel available at moment to test it, but probably this may work:
1. In your table, add a column SumQty, where you calculate the sum like in pivot using SUMIFS(). You get the same sum repeated for every row with same item and unit1; 2. In your table, add another 2 columns, where you calculate qty2 and qty3. Again, you get the same values repeated for every row with same item and unit1; 3. In pivot, along with sum of qty, calculate also average of qty2 and average of qty3. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding the same field in the column field list of pivot table | nanka | Excel | 4 | 03-19-2017 08:12 AM |
![]() |
John in DSM | Excel | 2 | 09-07-2016 02:12 PM |
Creating new field in pivot table based off existing field | laceymarie1987 | Excel | 0 | 06-26-2014 12:13 PM |
Pivot Table:delete zero values when using calculated objects | Serge 007 | Excel | 1 | 06-05-2013 11:47 AM |
Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |