How to acheive the average above the column for the field added into dimension

[#1]

Hi,

     I'm struck with finding the average to the field which i've added into dimension. When i add into the expression level i find diffrence in my data so i need it to acheive on the top of dimension only where i've added the field. When i give the avg(field) as an expression to dimension it gives avg for each row. I need it overall average of entire column on top of it. Can anyone please help me out to find it. will be very useful for me.

Regards,

Archana.

[sujeetsingh]

Archana it is little bit confusing.Please paste a sample .

[#3]

hi,

while evaluating avg expression in one of my reports, the redundent data was being pulled into the table chart which was not desired. if i disable the expression then the data depicted is correct.

[#4]

I tried it but it gives for each single data. I need the average for all data at the top.