Average and Sum of numbers in Pivot table

[#1]

Hi,

I have a unique requirement where I need to create a new column with Sum and Average of numbers.

For ex:

Table A

Field1     Field2     Site1     Site2     Total/Average

                             Actual  Actual  

Quality    Good      10        20          30(Sum of numbers) 

Quality    Bad        5         10           15(Sum of numbers)

Service    Good     90%     80%        85% (average of percentages)

Service    Bad       10%     50%        30%(average of percentages)

Field1 , Field2 and Site are Dimensions, and Actual is expression.

Let me know if you need any clarification on requirements.

Thanks a lot in advance.

[#2]

PFA.

Thanks,

Ram

[#3]

Hi Ram,

Thanks for your reply. I didn't mention the actual data before. This is how data is.

Above presentation is how I want it to appear.

Thanks

[#4 · Accepted solution]

PFA.

Thanks,

Ram

[#5]

Hi Ram,

Thanks for your reply.. it solved my problem. Cheers