Hi,

So I have a large amount of data that I currently use Vlookups to merge data and alot of formulas in calculated columns.

I then analyse this data using pivot tables. I am able to group dates and like data easily using the standard pivot tables.

I thought I'd have a go at trying to use Power Pivot instead (I mean it has the word "Power" in it!), hoping that I could reduce my file size and speed up calculations.

My very first hurdle is coming to grips with not being able to group data in a pivot table created using Power Pivot.

While I have discovered how to do date grouping, which is not intuitive, I don't know how to group other data fields together which I would normally do by a right-click on the field.

Can anyone guide me (read - convince me) that going down this Power Pivot (capital Ps people!!) path is going to better in the long run.

Thanks