|
|
楼主 |
发表于 2010-10-19 10:11
|
显示全部楼层
这里有讨论说是可以得到正确的值的,我测试了没有成功
http://www.officekb.com/Uwe/Foru ... -Price-wrong-Amount
Hi Edmund
I am an Excel MVP.
What you posted, was a sample where you used a calculated field.
The answer I gave you was correct, the Subtotal's and Grand Totals work in
the way I described.
If your Qty and Price were items in a standard set of data, then you can
create a Calculated Item within the Pivot table and the results will be
correct for both the lines and the Sub and Grand Totals.
Calculated Items work in a different way to Calculated Fields.
What you are now telling me, is that the file is quite different, is much
larger and is manipulated through OLAP cubes.
You cannot create Calculated Fields or Calculated items on Cube data.
You have measures and dimensions. Your Qty and Price will be measures, and
Value or Amount being Qty*Price would have to be a measure within the cube,
to have it shown in the PT. |
|
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2010-10-18 16:26
