Excel 2010 Pivot table

You can't do that with a regular pivot table, I'm afraid (unless it's based on an OLAP cube). You would need PowerPivot.

Originally Posted by romperstomper

You can't do that with a regular pivot table, I'm afraid (unless it's based on an OLAP cube). You would need PowerPivot.

Hi Rory,
Do you know any forum where PowerPivot is a main subject?

Hi Pepe,

I know that MrExcel has a PowerPivot section frequented by a few of the PP heavy hitters, including Rob Collie. There's also an Excel BI forum at VBAX although it's not that busy as yet, and the same with Ken's ExcelGuru site.

Other than that, I don't know of specific forums (I don't think even MSAnswers has one) but there are a few good blogs out there.

Originally Posted by geeka

Is powerpivot a really good tool?

It's extremely powerful. As a result, it can be massive overkill for some things, and extremely complicated for others, but it has some very useful features. Occasionally it's worth using for even simple pivots because by creating an OLAP cube as the source data for the pivot(s) it allows you to use things like asymmetric pivot tables (i.e. allows you to hide unwanted columns from the table).