Hi, I may be doing something wrong with the pivot settings or Gauge settings. Basically, I have a table with about 7 columns. I am trying to display the Gauge so that it shows the SUM of entire column 'ar30'.

The column 'ar' shows the total for that particular row. So the min. and max. of 'ar' needs to be the range in the gauge, and the pointer should point to the sum of 'ar30'.

I have attached a pic in the link below of the table that I'm working with. All help is appreciated.

http://i56.tinypic.com/2rdvlfd.jpg