Skip to Content
0
May 26 at 10:56 AM

move break based data from table 1 to table2

32 Views

Hi All.

I have a table with below columns and data. I need to display data in different pages as per different bank value.

Initial Data

Bank | Account No | Sum of Salary | Employee_Name`

ABC | 123 | 500.0 | Tom

DEF | 456 | 500.0 | ALex

GHI | 789 | 500.0 | Jatin

Required Output

Page 1 of webi report

Account No : 123

Bank | Sum of Salary | Employee_Name`

ABC | 500.0 | Tom

Page 2 of webi report

Account No : 456

Bank | Sum of Salary | Employee_Name`

DEF| 500.0 | ALex

And so on..

I am able to segregate data by applying break on account no and the data is shown in different pages but with table header as Bank | Account No | Sum of Salary | Employee_Name`.

Please suggest how i can extract the column with break into another table on same page.