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 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).

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?