Use the SAME FILTER 🧪for Multiple Pivot Tables - Hidden Excel Filter Trick

Use the SAME FILTER for Multiple Pivot Tables and revolutionize your data analysis workflow! Welcome to our latest tutorial on Excel, where we'll show you how to efficiently filter multiple pivot tables simultaneously using a single filter. If you've ever wondered how to apply the same filter to multiple pivot tables effortlessly, you've come to the right place.
Are you tired of manually filtering each pivot table separately? With our step-by-step guide, you'll learn how to save time and streamline your data analysis process. By following these simple steps, you'll be able to connect one filter to multiple pivot tables and effortlessly change them all at once based on your desired criteria.
First, we'll guide you through the process of creating a few pivot tables in Excel. Then, we'll demonstrate how to insert filters on the first pivot table. However, these filters will initially only affect the data within that particular table.
The real magic happens when we introduce slicers into the equation. We'll show you how to insert slicers and connect them to all of your pivot tables simultaneously. By doing so, you'll gain the power to filter multiple pivot tables at the same time with just a few clicks. No more redundant filter settings for each table!
But wait, there's more! We'll also reveal a special trick to hide the slicer, ensuring a clean and professional look for your Excel workbook. With our easy-to-follow instructions, you'll master the art of hiding the slicer while keeping its functionality intact.
So, if you're ready to unlock the secrets of using the same filter for multiple pivot tables, join us in this informative tutorial. Say goodbye to repetitive filtering tasks and embrace the efficiency of managing multiple pivot tables with a single filter. Watch our video now and revolutionize your data analysis workflow!
****************************Links
Data: mega.nz/file/P...
Completed: mega.nz/file/b...
#Excel #MsExcel #pivottable

[@EXCELWIZARDINMINUTES]

This is a cool trick to use one filter on all your pivot tables. No more having to update 10 filters every time you do an analysis!

[@BenjaminRaehpour]

That is a slick solution! I'm building a daily reporting dashboard right now, and this is exactly what I needed! Thank you!

[@EXCELWIZARDINMINUTES]

This could help you improve your dashboard. You can make nice navigation buttons: ua-cam.com/video/2-UZbXDSuPI/v-deo.html

[@QuynhTran-ld3sf]

It's very useful to build dashboard from multiple pivot tables!!! Thank you for sharing this :)

[@EXCELWIZARDINMINUTES]

U r welcome! 😊

[@tidrug1]

Thank you, friend. This was quite helpful!
One mistake I was making was not linking each slicer to the 2 tables :)

[@EXCELWIZARDINMINUTES]

excel can be sometimes frustrating. one small thing and we spend hours hehe

[@triplealley]

Wonderful explanation. I have this saved so I can come back and relearn it every year.
Note: I had trouble getting all the pivot tables in one sheet to be referenced in the slicer (even with the same data set). Basically, copy one of the referenced pivots and then adjust the fields if this happens.

[@EXCELWIZARDINMINUTES]

@triplealley heyy i also had different filters for year until i found this out.😅 For the tables in one sheet, make sure u keep space in case they expand. Otherwise u might get errors

[@preetib3036]

Wow.. .You just saved me so much time! Thank you for sharing this!

[@EXCELWIZARDINMINUTES]

@@preetib3036 😊😊

[@kroggybrizzane]

Great tutorial thanks! I knew this was possible but forgot how to do it

[@EXCELWIZARDINMINUTES]

Thanksss a lot! Yes Excel has so many things. It s so tricky 😅

[@alfeocayabyab8233]

Thank you. It works!

[@EXCELWIZARDINMINUTES]

@@alfeocayabyab8233 i m happy i helped 😊

[@KathiaM-fn3vq]

Love this! Very clear explanation which helped me to save time. Thank you for this.

[@EXCELWIZARDINMINUTES]

so nice of you to leave such a great comment :)

[@VijayYadav-jm3dc]

The last trick is literally a very useful information😁

[@EXCELWIZARDINMINUTES]

@VijayYadav-jm3dc so many hidden things in excel 😅

[@ronqmo8755]

Thank you thank you for this!!

[@EXCELWIZARDINMINUTES]

@@ronqmo8755 am happy it s useful 😊

[@cyrusezazi]

It was really useful. Thanks alot.

[@EXCELWIZARDINMINUTES]

@@cyrusezazi 😊😊

[@gmandjd]

Thank you, this made things so much easier!😀

[@EXCELWIZARDINMINUTES]

@@gmandjd my pleasure! 😍

[@paulabaoquiero]

Thank you so much! This is making my life so much easier!

[@EXCELWIZARDINMINUTES]

You are welcome Paula! :) i hope all my videos are like this hehe

[@EslamAbdo1919]

Thank you.

[@EXCELWIZARDINMINUTES]

@EslamAbdo1919 welcome Eslam! 😊

[@napattop]

Thank you. This is so benefit for my task.

[@EXCELWIZARDINMINUTES]

Now you can filter all tables at once 😅

[@gambheerjatt5470]

Superb - out of box

[@EXCELWIZARDINMINUTES]

😍😍😍

[@shoppersdream]

Nice, thanks!

[@EXCELWIZARDINMINUTES]

@@shoppersdream welcome! :)

[@honestuser11]

Thank you, will try it

[@EXCELWIZARDINMINUTES]

You are welcome! :)

[@mcacmg]

OMG UR MAKING ME LAUGH! AND ITS HELPFUL!!

[@EXCELWIZARDINMINUTES]

@mcacmg excel is so boring! Sometimes i use my creative side 😅

[@KB-nk7nk]

THANK YOU!!!

[@omidmashar]

Amazing tech thanks bro ❤❤❤

[@EXCELWIZARDINMINUTES]

U r welcome bro! Feel free to share the channel with anybody interested: ua-cam.com/users/excelwizardinminutes?submission=1

[@cpayan123]

thank you!

[@EXCELWIZARDINMINUTES]

You are welcome 😊

[@karnikkalani417]

I am not seeing the second pivot table in report connections what to do?

[@EXCELWIZARDINMINUTES]

I think this will help: www.skillademia.com/blog/pivot-table-slicer/#:~:text=However%2C%20if%20the%20%E2%80%9CReport%20Connections,the%20%E2%80%9CData%E2%80%9D%20group%20tools

[@humanbeing888]

Can i do without slicers?

[@EXCELWIZARDINMINUTES]

@humanbeing888 hard to achieve the same functionality. Vba coding might help though