Forum Discussion
How to split table?
Hi , can i ask for help? is there a way or formula that can split tables with filter? Like this for example? From this : To This : Or if possible, separate them by "LEVEL" into separat...
RanzieJ You can certainly do this and get "nearly" what you are looking for by using the Show Report Filter trick.
For your example, drop the "level" field in the Report Filter after you have laid out your Pivot Table.
Here is how: https://www.myexcelonline.com/blog/show-report-filter-pages-in-an-excel-pivot-table/
Thanks,
John Michaloudis
Microsoft MVP
Good idea. It's easy to overlook such functionality!