Google Sheets - Using Slicers to Filter a Pivot Table

[@el.dide_]

The problem is that the slicer is hiding the rows which causes the pivots to be unusable. E.g. at 00:07:00 you cannot see "Light Bulb" row for August in second pivot since the 18th row has been hidden as per slicers settings. It would be better for slicers not to hide raw data.

[@AroundHuaHin]

A little late maybe :) But you can place the pivot tables on a separate spread sheet and make the Slicers on the pivot table. It's working, but of course it's not updating data data-table behind the pivot.

[@SalesGuruGraphics]

i am watching this video in 2024..and its still worth it. Thanks a ton. Amazing and clear guidance

[@ProlificOaktree]

They haven't changed pivot tables on me....yet....

[@Sams0040]

At 8:17, Original data after slicer with three items, but both pivot tables are missing "paint" and "nails"

[@rogerhartley6630]

Excellent video, clear and simple instructions. THANKS!

[@ProlificOaktree]

Glad it was helpful!

[@bryonipidsley6575]

Thank you for the video. I've been ignoring slicers before now but can definitely use them now I know how they work. They make more sense if you put the pivot tables below the original data and each other as then the filtering doesn't impact all three. At the end of the video you should have been able to see Light Bulb,Nails and Paint in both pivot tables and the column headings.

[@alejandrocabrera6887]

Thank you for the info! I was looking for this and I'm legit going to use it at work right now.

[@ProlificOaktree]

Oh yeah!

[@rodrocdl]

Those birds are relaxing.

[@ProlificOaktree]

I'm glad you liked them. They've been with me for years now.

[@paullasar7796]

* Great demo - thank you! * Love the birds in the background. =:->

[@ProlificOaktree]

Thanks! I can't imagine the videos without them. They set the tone.

[@elmurat]

Thanks! Very helpful video. Is there any option to make the slicer Single Select? So that you ca select just one Date, not multiple dates?

[@beedleChompz44]

This was very helpful, thank you! I'm hoping to learn how to filter data within a specific range of dates. For example I want to look at "how many sales did I have in the last 30 days" or "how many sales did I have in the 30 days before March 15th"

[@ProlificOaktree]

Use a custom formula in the filter. You don't have to use a slicer, just use a filter if you want.

[@elizabethgray20]

Great video! At the end the amounts in the two pivot tables are different, why is that?

[@tejacavalera]

Previously I thought about allocating the range slicer in the pivot table, but it turns out it has to be in the source table. Thank You

[@ProlificOaktree]

Yeah, it gets easier once you realize that.

[@MrMosoani]

If we wanna share this via email and I’m using Chromebook by the way, how can I make the table smaller to fit in the body of the email? For some reason I don’t see options to resize it unlike Excel. Excel can be resized after pasting it on the body of the email.

[@antonydoss8994]

When I use multiple slicers and if one of the tables doesn't meet up with the condition set, I get a #Ref error and it says pivot evaluates to an out of bound rage. Even when I clear the condition set later the #Ref error stays and the pivot table doesn't appear again. How do I resolve this? Appreciate your support in advance.

[@rebm3028]

Hello, With the slicers of a pivot table, I can't keep the format (example wraps) As soon as I click on another segment, there is no more wrapping and the box is unchecked ...

[@rashmiranjan86]

Hi, I have my pivot tables in Sheet1 and my dashboard in sheet2. When I am moving the slicer from sheet1 to sheet2, the slicer doesn't work. Can you please help me here?

[@midhatfarrukh3034]

Can we link slicer with other Google sheet pivot table data ? I am a recruiter I want to show my total interviews efforts showing data month wise, recruiter wise and position wise

[@ProlificOaktree]

It has to be all in one table.

[@albertocastello170]

Thanks for the video! I have just one question I cannot find the answer on internet_: how can you hide annoying expand/contract button in a pivot table? Thanks! Greetings!

[@ProlificOaktree]

I don't think you can.

[@albertocastello170]

@@ProlificOaktree thanks! I thought it was possible, in your cideo they don't appear!

[@ProlificOaktree]

@@albertocastello170 Try the Sheet that's linked to the free course. That is the same file.

[@brigidageltz8604]

If I filter a value, the detail sheet still include all the data from that slicer's value and not just the sorted values. It's hard to explain

[@ProlificOaktree]

Maybe you're sorting instead of filtering? Or maybe you're filtering on the wrong column. There's always the chance that the filter is acting strangely as well. They can be finicky.

[@ziggerwebdesign1704]

The trouble is that we can't get the slicer to see new rows; every time I change the source from A1:B123 to A:B, it reverts to the specific range

[@mrsemmas12]

what if i created a table with slicers and dropdowns...how do i create a pivot table using that?

[@AdeKaryadi]

Nice tutorial

[@ProlificOaktree]

Glad you think so!

[@nithinjain411]

But the slicers does not work in Mobile View. Can you please help with it?

[@ProlificOaktree]

It won't work on mobile by design.

[@tracycooper8996]

This is silly. The "slicer" causes the table to filter, which hides the rows. The hidden rows are also hidden in the pivot tables, making them no longer useful. How can this video just ignore that??

[@ProlificOaktree]

That’s what they are designed to do