Budget: Aggregations
Aggregating Calculation Results
Aggregating Calculation Results
PivotTables are great at presenting summary views (aggregations) of data (as well as drill down into the details!). But sometimes we need more than just summations of data. Sometimes we need to perform calculations over the summarized data that normal PivotTables simply cannot do, but Power Pivot can!
In this section we will see how we can add such calculations, called measures. The measure we will create is the income/expense balance for any period.
Creating PivotTable Process Overview
Creating PivotTable Process Overview
Creating a hierarchy is simple:
Load table into the Data Model
Select category/sub category data elements
Select Create Hierarchy option.
Load Table into Data Model
Load Table into Data Model
asdf
Create Hierarchy
Create Hierarchy
asdf