I have a sheet of data with categories of data on rows, which I have grouped into their basic categories and can use the show/hide feature to expand or compact the category group. Meanwhile columns sort this data by period.
If I want to show one category of data for one period, and then another category of data for a different period. Not simultaneously though, just one group of rows and one group of columns at a time.
What is the procedure for doing this? What tool do I use?