Francois2France
New Member
- Joined
- Oct 24, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello
I have a pivot table showing the number of values of occurences. The Grand total of the pivot is 701.
1. If I double click one value (Show details), it opens a new sheet with the corresponding source lines. Good.
2. I filter the pivot table, showing only values different that 1 (see image). The Grand total of the pivot is 376.
3. If I double click the grand total value (Show details), it opens a new sheet with all source lines. Not only the ones that have been filtered in the Pivot table.
Question: how to get all sources lines corresponding only to the data filtered in the pivot table? (And not all source lines simply).
I have a pivot table showing the number of values of occurences. The Grand total of the pivot is 701.
1. If I double click one value (Show details), it opens a new sheet with the corresponding source lines. Good.
2. I filter the pivot table, showing only values different that 1 (see image). The Grand total of the pivot is 376.
3. If I double click the grand total value (Show details), it opens a new sheet with all source lines. Not only the ones that have been filtered in the Pivot table.
Question: how to get all sources lines corresponding only to the data filtered in the pivot table? (And not all source lines simply).