Grouping Dates in a Pivot Table

preview_player
Показать описание
Pivot Tables are a fantastic tool to do analysis and one of the things you can do is to group row fields that are dates. If you have dates like 1/1/2016 in your source, once you put it into a Pivot Table you can group those dates into years, months or days (there isn't a week option, but there's a workaround). You can also use a timeline feature to further group your dates, although this might be more of a filtering capability. Nevertheless, grouping is a nice feature to help you perform further analysis on your data.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-
  1. Doug H
  2. training
  3. easy
  4. system
  5. dough
  6. formula
Рекомендации по теме
Grouping Dates in 0:00:39

Grouping Dates in Pivot Table

Excel Pivot Tables: 0:01:02

Excel Pivot Tables: How to Group Dates into Years and Months

Properly Handle Date 0:13:54

Properly Handle Date Grouping and Missing Dates in Excel Pivot Tables (show all dates)

Excel: Grouping Dates 0:01:50

Excel: Grouping Dates in a Pivot Table By Week

Excel Cannot Group 0:04:33

Excel Cannot Group Dates in Pivot Table? Here's How to Fix it! 🔨

Creating Week-Wise Groups 0:00:40

Creating Week-Wise Groups from Dates in Pivot Table | Excel Tutorial

Excel Pivot Table: 0:01:14

Excel Pivot Table: How to Group by Month

MS Excel - 0:04:45

MS Excel - Pivot Table Grouping

Don’t Use Pivot 0:00:25

Don’t Use Pivot Table! Use GROUPBY Function Instead | Smarter Data Analysis 💡

Excel Pivot Table: 0:00:51

Excel Pivot Table: How to Group By Week

Grouping Dates in 0:05:33

Grouping Dates in Excel Pivot Table Show Extra Items

Grouping Dates in 0:12:34

Grouping Dates in a Pivot Table

Pivot Table Not 0:00:27

Pivot Table Not Grouping Dates | Fix 1

How to Group 0:08:09

How to Group Dates in Pivot Tables in Excel

Pivot Table Not 0:00:27

Pivot Table Not Grouping Dates | Fix 2

Pivot table - 0:00:33

Pivot table - group ungroup date #Excel #excelhacks

Unable to Group 0:01:56

Unable to Group Dates in Pivot Table | Cannot group that selection | Excel

Pivot Table Trick 0:00:49

Pivot Table Trick 4 - Group Date Fields (Must Know!)

Group Pivot Table 0:00:38

Group Pivot Table dates into months WITHIN the Pivot Table

How to group 0:00:23

How to group pivot table data in excel

Customise a Pivot 0:05:24

Customise a Pivot table by grouping dates and categories

Group Dates in 0:07:10

Group Dates in a Pivot Table

Google Sheets: Pivot 0:02:57

Google Sheets: Pivot Table date grouping by month, quarter, day of week, week of year

Group by Dates 0:05:16

Group by Dates Using Power Pivot

Комментарии
Автор

Wow, you solved in 30 seconds what I have been trying to figure out for hours. Thank you so much!

erick
Автор

Extremely Helpful and your directions/visuals were easy to understand!

ebonywashington
Автор

Thanks for this video! Very clear ! It's good that you also show something not working and show how to find it too. Definitely helps in my interview assessment next week !

melr
Автор

You are an amazing teacher Doug. Thanks for this tutorial.

marellasrikanth-us
Автор

This tutorial was extremely helpful. Thanks Doug :-)

alexrosen
Автор

how to group daily hours logged by resources into weeks based on the month

maheshus
Автор

Is there any way to group dates using power pivot instead?

flyeract