Connect One Slicer to Multiple PivotTables (Same Data Source OR Different Data Sources) I MS Excel

Подписаться 358

Просмотров 3,1 тыс.

50% 1

Connect One Slicer to Multiple PivotTables (Same Data Source OR Different Data Sources) I MS Excel
In this excel tutorial, I demonstrate how to filter multiple PivotTables using SLICERS by creating relationships based on:
Scenario 1: Multiple Pivot Tables from Single data source i.e. data file.
Scenario 2: Multiple Pivot Tables from Multiple Data files.
The key step in this process is to employ Excel's data model which allows you to create relationships between the different data sources.
These are very useful while making Interactive dashboards.
My short on Slicers: • Excel Slicers to filte...
My Video on PivotTables: • PIVOT TABLES- All you ...
My Excel Playlist: • Create an Organization...
Your Queries:
excel
Pivot Tables
connect slicer to multiple pivot tables different data source
how to connect 1 slicer to 2 different data sources
connect slicers to multiple excel pivot tables
connect excel slicers to multiple pivot tables
excel slicers
excel pivot table
connect excel slicers to pivot tables
microsoft excel
excel one slicer for multiple pivot tables with different data source
create pivot table from multiple worksheets excel
Slicers for dashboard in Excel
Filtering by slicers in MS excel
Thanks for watching this tutorial, don't forget to like, comment & share it with your friends.
🔔 SUBSCRIBE ON RU-vid:
ҠąӀքąղą PⱮ 😎: @KalpanaPM_DataIsVital: / @kalpanapm_dataisvital
🔽 CONNECT WITH ME
LinkedIn: / kalpana-magar-350156232
Facebook: / kalpana.magar.940
Instagram: / kalps_pm
#msexcel #exceltips #exceltutorials #excelformulas
#excel #exceltutorial #exceltips #exceltricks #exceltrick #excelsupport #msexcel #msexceltricks #microsoftexcel #microsoftexceltutorial #excelfunction #excelfunctions #msexcelformulas #viral #viralvideo #viral_video #trending #trendingvideo #trendingstatus #trendingtutorial #trendingvideos #spreadsheets #corporate #excelspreadsheets #workhacks #sheets #excelshortsvideo #excelsheets #finance #accounting #excelguide #filters #slicers #pivot #pivottables #pivotchart #slicer #excelfilter

Опубликовано:

3 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 14

@Aaliya_parvez 6 месяцев назад

Good job

@sanishtv 6 месяцев назад

Thanks for the helpful video, but only want to confirm if we should make Product table also as Data Model. I think u missed to show that. But when we make relationships, there we can see in the drop down list Product table named as "Data Model: Produt". So, I want to confirm that sheet also need to convert Pivot table with data model option or just leave it as a common table only for slicer

@KalpanaPM_DataIsVital 6 месяцев назад

@sanishtv, Glad you liked the video🙏 Well we get an option "add it to data model" only while making pivot tables, so no need. The existing worksheets in a workbook are automatically considered as a part of data model. Thank you😊

@CelPeterineOrias 6 месяцев назад

It all worked on my end. Thanks! Just have a quick question, how to sort the month chronically? My slicer is for the month. Looking forward to your feedback. Thanks again!

@KalpanaPM_DataIsVital 6 месяцев назад

Glad you liked the video🙏 Well to sort the months (or days) chronically, you will have to create helper columns, month number(1-12), days no. (0-6, 0 Monday... 6- Sunday), Once created, sort month column based on the helper column. I do not have any specific video on the same but I find this one on-spot: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Z55s9XlHEBc.htmlfeature=shared