Forum Discussion
Split dataset into two reports
I am working on a dataset like below.
First 4 rows are one grouping. Next 3 rows are another grouping.
While creating reporting, I would like to have two scheets each with their own grouping.
| Trn | Type | SNo Ref | Sender | Receiver |
| ewew | new | 22324 | Aaron | Tim |
| bbgg | old | 24334 | Ben | Carr |
| hnhn | new | 53454 | Aaron | Tim |
| hnhm | new | 44455 | Meg | Alen |
| ghjui | old | |||
| hnmm | old | |||
| eghgh | old |
Hi Anonymous
Below is what I suggest.
1) Import whole table into powerquery (will name it as table A).
2) Right click and then refrenece. This new table rename it as table B. In table B, go to Home tab and then keep rows. Select keep top rows and enter 4.
3) same as step 2 but use remove top rows and enter 4.
4) right click on table A and then uncheck enable load in queries pane.
Thanks
thingsclump
Mark it as accepted solution if it solves ur problem.
3 Replies
isnt clear what you looking for, give a example or a more detailed explanation
The excel table is structured as shown in the above table. This excel sheet is in a folder which is updated with one new excel file same as the above table every week.
I am looking to create a report out of first 4 rows seperately and the last 3 rows seperately. Once set, I will keep on refreshing the report for latest week's data.
Hi Anonymous
Below is what I suggest.
1) Import whole table into powerquery (will name it as table A).
2) Right click and then refrenece. This new table rename it as table B. In table B, go to Home tab and then keep rows. Select keep top rows and enter 4.
3) same as step 2 but use remove top rows and enter 4.
4) right click on table A and then uncheck enable load in queries pane.
Thanks
thingsclump
Mark it as accepted solution if it solves ur problem.
