Once I am "in" a pivot sheet, is there an easy way to click on a row or cell in the Pivot table and navigate directly back to the related data in the original database (Google Sheet), from which the Pivot table was derived. The use case would be a pivot table showing, for example, just the name of a salesperson and what territory s/he was assigned, clicking on the salesperson name would take you back to that row, or the first of the rows that included the salesperson's name and all the other data (columns/fields) in the original Google Sheet (database).
Google-sheets – navigate from a pivot table back to the original database
google sheetspivot table
Related Topic
- Google-sheets – Aggregate data with Sheets pivot table or graph
- Google Sheets – Custom Script in Pivot Table Value Formula Error
- Google-sheets – How to count duplicate names as one value in Sheets
- Google Sheets – Create Table Showing Difference Between Two Pivot Tables
- Google Sheets Formulas – Syntax for Custom Filter by Condition in Pivot Table
- Google-sheets – Splitting data in one row into two
Best Answer
Pivot table jumps are just one-way ticket rides. These options are closest you can get: