How to Keep Pivot Table Visible When Filtering Another Table in Google Sheets?

AppSheet AppSheet Q&A
1

Hello everyone,

I’m working on a project in Google Sheets where I have two sections within the same sheet. The first section contains detailed data about various items, and the second section is a pivot table summarizing that data.

Here’s the challenge:

  • I need to filter the first section based on specific criteria (e.g., a particular item name).
  • When I apply the filter, the pivot table on the right side of the sheet should remain fully visible and not be hidden or partially obscured.

Example scenario:

  • The first section (A

    ) contains item details.

  • The pivot table (S

    ) summarizes these items.

  • If I filter the first section to show only rows for a specific item, I need the pivot table to stay visible and fully intact.

Has anyone encountered a similar issue or have any tips on how to achieve this in Google Sheets?

Thanks in advance for your help!

1 Like
2

Hi! Be informed that this is an AppSheet app Community forum. You will want to repost your question in a forum dedicate to Google Sheets.

1 Like
3

where is it?

4

did you find a solution to this? i’m having the same problem

1 Like