开发者

How do I access subtotals from a pivot?

开发者 https://www.devze.com 2023-03-18 19:42 出处:网络
I\'ve got a pivot with an av开发者_运维技巧erage value and I need to be able to access it in another spreadsheet, how can I do this? It seems like I cannot access any subtotals.

I've got a pivot with an av开发者_运维技巧erage value and I need to be able to access it in another spreadsheet, how can I do this? It seems like I cannot access any subtotals.

Heres the value of the cell:

=GETPIVOTDATA($A$3,"'1/2/2011 - 1/8/2011' operation_id['4';Data,Average] 'Sum of Estimated Hours / Paid Per Operation'")

Mousing over the #REF seems to indicate that there are missing or deleted cells but I haven't deleted anything.


http://office.microsoft.com/en-us/access-help/about-calculating-totals-in-pivottable-view-HP003084426.aspx

"Callout 1 The Sum of Sales total field. You cannot add total fields to the row, column, or filter area."

0

精彩评论

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