FrankensTeam's Excel Collection
106.5K views | +40 today
Follow
FrankensTeam's Excel Collection
Useful, interesting and funny Excel stuff
Curated by Kris
Your new post is loading...
Your new post is loading...
Scooped by Kris
Scoop.it!

Introduction to MDX for PowerPivot Users, Part 1

This is a series of posts I’ve wanted to write for a long time. The more I use PowerPivot, the more I realise how many more cool things you can do when building your Excel reports if you know a bit of MDX. Of course it seems a bit strange to say this, because (at…
more...
No comment yet.
Scooped by Kris
Scoop.it!

Sort the Power Pivot measures (and fields) in the PivotTable Fields

Sort the Power Pivot measures (and fields) in the PivotTable Fields | FrankensTeam's Excel Collection | Scoop.it
When designing your pivot tables based on a Power Pivot model you typically add fields and measures continuously, and in the measure list they will by default list then be sorted by the order you h...
more...
No comment yet.
Scooped by Kris
Scoop.it!

Introducing… the Calendar Chart! « PowerPivotPro

Introducing… the Calendar Chart! « PowerPivotPro | FrankensTeam's Excel Collection | Scoop.it

Brilliant Calendar Chart solution, must see and must try! Really amazing!

more...
No comment yet.
Scooped by Kris
Scoop.it!

Use Slicer to select value fields for Pivot table or PowerPivot! - E90E50fx

Use Slicer to select value fields for Pivot table or PowerPivot! - E90E50fx | FrankensTeam's Excel Collection | Scoop.it
Use Slicer to select value field, measure for Pivot table or PowerPivot
Kris's insight:
Do you like this trick?
more...
No comment yet.
Scooped by Kris
Scoop.it!

Excel PowerPivot PivotTable Named Sets

Excel PowerPivot PivotTable Named Sets | FrankensTeam's Excel Collection | Scoop.it
Excel PivotTable Named Sets enable you to pick and choose which column or row labels to include in your PivotTable reports.
more...
No comment yet.