Average Data in Pivot with Sum in Total

[Tammy Levasseur]

I have a spreadsheet with data and I want to show the average of the data by discipline (which is doable) but in the Total I want to sum the average data. Is this possible. When I add the Total to the Pivot it provides the average of the data. Below is a sample: CHK, DES and ENG are disciplines and the data is an average of each discipline on the 3533001.2521 row I would like a total of the averaged data. Let me know if there are any solution. I've read about power pivot. Not sure if that is what is required.

[TABLE="width: 579"]
<tbody>[TR]
[TD]3533001.2521
[/TD]
[TD="align: right"]22
[/TD]
[TD="align: right"]33
[/TD]
[TD="align: right"]67
[/TD]
[TD="align: right"]41
[/TD]
[/TR]
[TR]
[TD]CHK
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]3
[/TD]
[/TR]
[TR]
[TD]DES
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]53
[/TD]
[TD="align: right"]31
[/TD]
[/TR]
[TR]
[TD]ENG
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]9
[/TD]
[TD="align: right"]11
[/TD]
[TD="align: right"]7
[/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

can you just calculate it from the original data ? ie don't use a pivot table ?

 

[Tammy Levasseur]

There are several layers of grouping. The above is just a small snippet of the actual pivot. I would have to do a lot of averageif statements and then sum that. It might be a solution if I can't get the pivot to work.

 

[oldbrewer]

[TABLE="width: 896"]
<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"][/TD]
[TD="class: xl24"]test1[/TD]
[TD="class: xl24"]test2[/TD]
[TD="class: xl24"]test3[/TD]
[TD="class: xl24"]test4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHK[/TD]
[TD]test1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]CHK[/TD]
[TD="class: xl24"]1[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DES[/TD]
[TD]test1[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]DES[/TD]
[TD="class: xl24"]20[/TD]
[TD="class: xl24"]20[/TD]
[TD="class: xl24"]53[/TD]
[TD="class: xl24"]31[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ENG[/TD]
[TD]test1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24"]ENG[/TD]
[TD="class: xl24"]1[/TD]
[TD="class: xl24"]9[/TD]
[TD="class: xl24"]11[/TD]
[TD="class: xl24"]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHK[/TD]
[TD]test2[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DES[/TD]
[TD]test2[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ENG[/TD]
[TD]test2[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHK[/TD]
[TD]test3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DES[/TD]
[TD]test3[/TD]
[TD="align: right"]53[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ENG[/TD]
[TD]test3[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHK[/TD]
[TD]test4[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DES[/TD]
[TD]test4[/TD]
[TD="align: right"]31[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]the above table made with sumproduct formula[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ENG[/TD]
[TD]test4[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]easy to add totals for rows and columns[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Tammy Levasseur]

Thank you,

The data should be an average. My above example is an average of a much larger data set. For example, in your example Test1 DES is 20. My data would say Test1 DES is 10,20, 30, My pivot table averages all that data to 20.

Hope I'm making sense.

Tammy

 

[oldbrewer]

where does 10,20,30 come from

is the layout of my data wrong - are all the tests test1 ?

 

[Tammy Levasseur]

Hi Oldbrewer

My example was an actual pivot table with the data averaged within. Not the raw data. The raw data would look something like this. Just a sample and does not align with my earlier pivot table however you can see Test1 DES is 10, 20,30 and the Pivot Table had averaged that data to 20.

[TABLE="width: 220"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Actual Hours[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]DES[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]DES[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]DES[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]ENG[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]ENG[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]ENG[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]CHK[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]CHK[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]CHK[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]DES[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]DES[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]DES[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]ENG[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]ENG[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]ENG[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]CHK[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]CHK[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]CHK[/TD]
[TD="align: right"]20[/TD]
[/TR]
</tbody><colgroup><col><col span="2"></colgroup>[/TABLE]

 

[oldbrewer]

[TABLE="width: 1024"]
<colgroup><col width="64" span="16" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Test1[/TD]
[TD="width: 64"]DES[/TD]
[TD="width: 64, align: right"]10[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]DES[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]DES[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]ENG[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]ENG[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]ENG[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]CHK[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]CHK[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]DES[/TD]
[TD]ENG[/TD]
[TD]CHK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test1[/TD]
[TD]CHK[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Test1[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]DES[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Test2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]DES[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]DES[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]ENG[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]ENG[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]20 COMES FROM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]ENG[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]CHK[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 7"]=SUMPRODUCT(($A$1:$A$18=$G9)*($B$1:$B$18=H$8)*($C$1:$C$18))/3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]CHK[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test2[/TD]
[TD]CHK[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 7"]I have divided by 3 but not hard to calculate the 3 to allow for more raw data[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]you have 18 rows, 2 tests = 9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]you have 3 DES ENG CHK 9/3 = 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Tammy Levasseur]

Thanks, I'll give it a try. I was hoping to keep in in a pivot table because there is a filter variable that I wanted to be able to switch between but it may not be possible.

Thanks

Tammy