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
More PowerPivot Tricks from MrExcel!
Bill Jelen, Chandoo and Rob Collie = Excel-lent Topics!
Dates in Text Format in my Pivot Table! We can fix that!