开发者

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

Pivot Summarize: Use 2 different aggregation

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜