Pivot Summarize: Use 2 different aggregation
In a pivot I need 2 level aggregation for a column sales
.
I need to find the average of sales per product for each country. And then add these average sales to get the total.
In short SUM( AVERAGE(sales) per product) percountry
How is it possible in excel pivot. (preferably using normal excel pivo开发者_如何学Ct)
The below method (in picture) did not help
精彩评论