Hello
I have data source, pivot table and a simple calculation outside the Pivot table (yellow hilited cells). Please see the attachment. The problem is when new data input and the Pivot table refreshed, my calculating cells are thrown off.
Any idea to calculate within the PT or at least, the calculation outside can "stick" with the new data input?
Thanks
Bookmarks