Hi,
I have a pivot table that calculates data based on values put into a series of input boxes. On this table I have it showing partial sums in order to get the totals per column.
The input boxes are used to add weighting to the calculations, so if 100 is entered then it will show 100% of the original value, 50 will show 50%, and so on. The totals will always show the total of the the original values no matter what value has been added in the input box, even though the data in the table itself updates correctly.
Does anyone know what the issue could be and how to get the totals to reflect the values in the table?
Thanks
