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

[Kichoo]

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!

[WillowMobileSys]

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.

[Kichoo]

where is it?

[wj1]

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