Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Splitting a table at an unfixed row

Hello,   I am trying to make dashboards using datas which use a quite particular format. Some of the tables I have contain two or three sub-tables, with the top row of the next ones being at the e...
Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi,

    you can take a look at the attached file

    first duplicate twice your query

    Now use one query to find the position of Client in the list, by duplicating the query, drill down on the column and then utilizing List.PositionOf

    Then you can use one query to keep top rows 

    use the UI to write the step for deliting 1 row then substitute in the formula bar 1 with Position (the result of the first query)

    use position -1 

    then do the same to remove top rows

    If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution

     

     

serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
3 years ago

Hi,

you can take a look at the attached file

first duplicate twice your query

Now use one query to find the position of Client in the list, by duplicating the query, drill down on the column and then utilizing List.PositionOf

Then you can use one query to keep top rows 

use the UI to write the step for deliting 1 row then substitute in the formula bar 1 with Position (the result of the first query)

use position -1 

then do the same to remove top rows

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution