Hello,
I'm not sure if this is possible. I want to calculate data using pivot table data, but not within the pivot itself.
This example data works giving me the totals, but if I would filter pivot data by AR Coordinator, data doesn't change. Is it possible to write a formula that will work and refresh when pivot data increase/decrease or when filtered?
Formula syntax.....=(GETPIVOTDATA(" Amount",F3304:I3304)-SUM(D3304:E3304)); this is first line of data for >30 days but looks at the current Grand Total row (3304).
> 30 Days $18,711,032
> 60 Days $10,493,640
> 90 Days $6,637,459
I don't know how to send pivot data without confidential info, but I have attached image of field names; obviously bottom row is Grand Total.
Bookmarks