When you run your Data through PowerPivot, you can not group daily dates up to Months & Years as you can with a regular Pivot Table. Back
Rekha viewed ‘Learn Excel from MrExcel‘ Episode #655 where I used Group Field in a Pivot Table to create a year-over-year report. But Rekha needs Back
This 3-day event is aimed squarely at business analysts and managers who find it increasingly necessary to become more efficient at working with “big data” tools traditionally reserved for IT professionals. Excel MVPs Bill Jelen (MrExcel) and Mike Alexander (DataPig Technologies) guide you through the mysterious world of Microsoft’s new BI Tools from a business analyst’s point of view. (…)
More PowerPivot Tricks from MrExcel!
Dates in Text Format in my Pivot Table! We can fix that!