pivot calculation

Hello, Is there a way to add a field in a pivot table, that is the remainder of the total? I see there is a running total, % of grand total. But is there a remainder of total? so the total is 100 row one has a running total of 10, so the remainder of total is 90 row two has a running total of...

Hello, I have a table of data in Excel 2010 that looks like this: After transforming the data into a pivot table and adding a calculated field ‘Quality x Number’, it looks like this: The field list looks like this: What I am trying to do is add a ‘Real Quality’ column or calculated...

Hello, Is there an easy way to get 'OT divided by Grand Total' in the pivot table? I need it to be a field in the pivot table so that the calculated fiend changes when putting new Cities in the pivot table. I really apprecaite any help!! <TABLE style="WIDTH: 670pt; BORDER-COLLAPSE: collapse"...