Pivot tables

[jasonpfuhrman]

I have created the following pivot table, and I want to change all the data listed below on the left side of the table from average to sum all at the same time without using a macro or an add-in. Please help. Thank you.

<table style="border-collapse: collapse; width: 97pt;" border="0" cellpadding="0" cellspacing="0" width="129"><col style="width: 97pt;" width="129"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; width: 97pt; font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" height="15" width="129"> <table style="border-collapse: collapse; width: 818pt;" border="0" cellpadding="0" cellspacing="0" width="1090"><col style="width: 97pt;" width="129"> <col style="width: 142pt;" width="189"> <col style="width: 63pt;" span="5" width="84"> <col style="width: 66pt;" span="4" width="88"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; width: 97pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" height="15" width="129">Industry</td> <td class="xl65" style="width: 142pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" width="189">Communications Equipment</td> <td class="xl65" style="width: 63pt;" width="84">
</td> <td class="xl65" style="width: 63pt;" width="84">
</td> <td class="xl65" style="width: 63pt;" width="84">
</td> <td class="xl65" style="width: 63pt;" width="84">
</td> <td class="xl65" style="width: 63pt;" width="84">
</td> <td class="xl65" style="width: 66pt;" width="88">
</td> <td class="xl65" style="width: 66pt;" width="88">
</td> <td class="xl65" style="width: 66pt;" width="88">
</td> <td class="xl65" style="width: 66pt;" width="88">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> <td class="xl65" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);" height="15">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">Year</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; background: none repeat scroll 0% 0% rgb(216, 216, 216);">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" height="15">Data</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">1995</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">1996</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">1997</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">1998</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">1999</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">2000</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">2001</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">2002</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);" align="right">2003</td> <td class="xl65" style="font-size: 8pt; color: black; font-weight: 700; text-decoration: none; font-family: Arial; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(165, 165, 165); background: none repeat scroll 0% 0% rgb(216, 216, 216);">Grand Total</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of Net Sales</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">13094.96</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">12409.64</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">16118.52</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">17793.46</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">21493.55</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">24824.89</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">21062.05</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">15815.37</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">14889.69</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">17500.24</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of COGS</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">4011.32</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">3932.52</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">4895.59</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">5369.70</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">5762.80</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">6832.68</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">6855.26</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">4514.52</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">3837.75</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">5112.46</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of SG&A</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">1255.53</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">1172.19</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">1557.85</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">1810.97</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">2456.99</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">2698.09</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">2933.20</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">2315.54</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">1934.15</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">2014.95</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of Int Exp</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">174.42</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">151.95</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">175.71</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">206.04</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">239.89</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">273.69</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">349.13</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">327.50</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">310.39</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">245.41</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of Inc Taxes</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">108.55</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">137.75</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">243.84</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">203.03</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">358.99</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">500.66</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-692.54</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">380.81</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">160.51</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">155.73</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of EPSBasic</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">0.30</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">0.40</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">0.58</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">0.52</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">0.73</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">1.01</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-7.20</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-1.48</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">0.15</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-0.55</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of ROA</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">16.62</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">15.70</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">18.35</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">12.61</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">17.05</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">20.42</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-96.64</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-77.54</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-5.26</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-8.74</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of ROE</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">17.80</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">33.29</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">39.67</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">27.94</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">35.09</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">34.35</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-164.86</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-112.52</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-8.04</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-10.81</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl65" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">Average of ROI</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">12.77</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">19.81</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">24.43</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">16.26</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">21.59</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">24.23</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-111.56</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-177.37</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-11.42</td> <td class="xl66" style="font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" align="right">-20.14</td> </tr> </tbody></table></td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> <tr style="height: 11.25pt;" height="15"> <td class="xl63" style="height: 11.25pt; font-size: 8pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Arial;" height="15">
</td> </tr> </tbody></table>

 

[pagrender]

Welcome to the board.

I don't know how to change them all at once. I'm sure someone out here does - they can always come up with such great solutions.

To change one field at a time, right click on the field, choose Field Settings, and choose Sum.