View Single Post
  #6   Report Post  
Old October 13th 09, 02:51 PM posted to microsoft.public.excel.misc
Richard A Richard A is offline
external usenet poster
First recorded activity by ExcelBanter: Oct 2009
Posts: 1
Default Using text values in Pivot Tables

It should show the max() or min() values, evaluated alpha-numerically, which
are options for Excel pivots and which work in SQL (even Access) despite
being aggregate functions there, too. Is Microsoft working on an add-in for
Excel that will allow this?

"Jim Thomlinson" wrote:

Your only choice is row and column headers. Pivot tables aggregate data in a
cube. The data secton shows the aggregation of those fields. It can not show
text associated with those aggregations. The reason being is that the
aggregation may contain values with more than one descriptor at which point
what should it show.

A simple example...
Region / Location / Sales

If I place the region in the left column and sales in the data section then
the aggregation of the region will have multiple locations assocatied each
data value. Now if I add location to the data section what should it show???

Jim Thomlinson