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???