Skip to Content
Feb 16, 2021 at 09:14 AM

Copy a variable from one report tab to another report tab

219 Views Last edit Feb 16, 2021 at 11:19 AM 3 rev

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.