| PowerPivot: Grouping By Dates (Months, Quarters, Years, etc.) in PivotTables |
| Written by Microsoft |
| Tuesday, 29 June 2010 21:24 |
|
When you create a PivotTable that is based on Excel data, you can group the data in the PivotTable. For example, the source data for a PivotTable might contain a column that stores the sales date, but you can also see the data grouped by quarters or months, rather than days. Note: You can use grouping for other types of data, but I will focus on dates here.
|
Author articles
- DAX in the BI Tabular Model Whitepaper and Samples
- Tutorial: Optimize a Sample PowerPivot Model for Power View Reports
- Power View and PowerPivot HelloWorldPicnic Samples for SQL Server 2012 RC0
- What's new in PowerPivot for Excel with SQL Server Code Name "Denali" CTP3
- Analyze data from SQL Server Analysis Services
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
