Refferencing Table Cell

[Former Member]

Dear All.

i have a required to show the maximum production qty and the date i am using bex query and include all the time characteristics i.e. Calday, week, month and year.

now in WEB i am consuming query with separate sepate characteristic with the maximum qty key figure and using the Rank function on each table and it works perfectly fine.

the problem is i am arrangin table in a row in form of columns and it shows perfecly fine in WEBI report but when i export to excel it shows tables separated every where in excel sheet.

if there is a way to reffrence table cell i can easily perform the job.

Kindly please help to find the solution.

[Former Member]

Always use the Relative postiong while creating multiple talbes in WEBI.

setting up the relative position solve the issue

[Former Member]

Hi

When you save a webi report in Excel, Excel contains the formatting and data of the report, you cannot reference a single cell between Webi and Excel.

Regards

Federica

[Former Member]

Dear Fedric.

I dont want to refference cell between webi and excel i want to access the value in table i.e webi table block

Let say showing the value on label from the table cell within webi

Thank you