I created a variable in one report tab which contains the average of several columns for each row. I tried to drag this variable into a new column of another report tab. However, the values do not match.
What I wish to do is equivalent in excel to copy one column from one worksheet that contains a formula and paste this column as a number in another worksheet.
I tried to reference a cell but it does not work. It copies only the first value as a constant to the whole column.
App: SAP Business Objects - Web Intelligence Rich Client
EDIT: include pictures of data sample
So, in the first report tab I have a cross-table. The first column is a dimension that represents the ID of the products, the second column is a variable that constains the average of all values across the different weeks for each product ID.
What I wish is to copy this AVG variable that is located in the Average_created tab to the report in the Average_copied tab.
However, when I copy this variable, I obtain a different result as you can see in the picture below.