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.