开发者

Pivot Summarize: Use 2 different aggregation

开发者 https://www.devze.com 2022-12-07 18:18 出处:网络
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 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

Pivot Summarize: Use 2 different aggregation

0

精彩评论

暂无评论...
验证码 换一张
取 消