Hello Gurus,
I have problem with query,...this is simle example what I need to do actually,...
that is my data:
Amount = firs column, Sum = second coulmn, Average=third coulmn
AAA 1 5 5
BBB 2 12 6
<u>CCC 3 21 7</u>
Sum 6 38 18(6.33)
I need to do couting (for example) after first three rows. The result is in first column 6, what is true,....123=6,....in second column that is 38, what is true also, because 51221=38 but in third column is result false!!!!!!!!! 5 + 6 + 7 = 18, but average is not 18!!!! Average is 38/6!!!! this is what I need to get, I need to buid query with subtotal 38/6=6,33.
18 is just sum of column(Average),...but I need to get "avegage of averages"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Could you please send to me any suggestions? What should I do???
Thanks.