I am using Bex 3.5 and I need to create a column in which the value should be average value of a different key figure column. I need to have same value in each row of this column which should be the average of the key figure column.
Can you advice me how to do it?
Also, I want to have a column which should show me "total" number of records in the report. When I tried, I am getting value 1 in every row.
Please note that I am using Bex 3.5 and not Bex 7.0