Pivot Table to Show difference between Min and Max Value

[bigroo1958]

Hi All,

Please review my attached file for details but here is what I wish to do.

I wish to find the Min and Max value of column C, eg 4233 as min and 6966 as max and within row 34 where total is displayed show the difference as 2734 at C34 highligthed in green PTableTest.xlsxinstead of total of that column.
This is only one serial number I am showing on this report, but can have hunderds of serial numbers. I have also hidden the other meter names but the same will need to be done for these also.

Does anyone have any ideas how to do this?
Thanks in advance for any assistance!

[bigroo1958]

Thanks to those that have looked at my question.
Is there another way I can do the calculations as I have outlined in my post?

I am open to suggestions!!