Hi,
I've created a pivot of a data matrix to get an easy readable overview. I also use this pivot to get to the details of interesting data by double click on the data.
Every time I do this Excel opens a new sheet with the detailed data.
I was wondering if t's possible to show these details on the same sheet as the pivot as a fixed details area?
Many thanks, Hans!
I've created a pivot of a data matrix to get an easy readable overview. I also use this pivot to get to the details of interesting data by double click on the data.
Every time I do this Excel opens a new sheet with the detailed data.
I was wondering if t's possible to show these details on the same sheet as the pivot as a fixed details area?
Many thanks, Hans!