当前位置: 动力学知识库 > 问答 > 编程问答 >

Excel 2007 Pivot Table, Different Formulas in Different Columns

问题描述:

Created a Pivot Table in Excel 2007, and it seems I can only make it do one type of calculation at a time.

Is it possible to provide an average in one column, and a sum in the next?

When I click on "Value Field Settings", choosing any of the options applies it to every column in the Pivot Table, can't figure out how to apply it to only one column.

网友答案:

You can have a different calculation.

When you drop a field into the data section of the pivot change the calculation to sum.

Then drag the same field across again this time change it to average

分享给朋友:
您可能感兴趣的文章:
随机阅读: