Piviot Table Data

  • Thread starter Thread starter Ty Wilson
  • Start date Start date
T

Ty Wilson

Hopefully this makes some sense...

Let's pretend:
In my source data, I have X columns: Product, Total Sales,
Region and Quarter.

In a pivot table, I would like to establish PRODUCT as my
rows, and QUARTERS for my columns. Then in the data area,
I would like to display the max of TOTAL SALES and the
REGION that generated the Max TOTAL SALES for that
QUARTER. The problem is that the REGION data is text, and
the data area of the piviot table is designed to perform
mathmatical functions, not just display related info. I
don't want to put the REGION into a Row or Column, because
all I am really interested in looking at is the region
that generated the Max TOTAL SALES for that QUARTER. (I
tried putting REGION is a row and using the AutoShow
function, but that creates problems because the top REGION
varies from QUARTER TO QUARTER for each PRODUCT.)

Is there a way to show text in the data section without
performing a mathamatical function on it? Any other
ideas? Thanks.
 
performing a mathamatical function on it?>>
Click to expand...

No. But you can double click the grey field tab in the PT Wizard and
change it to 'Count'. I sometimes hide the column that contains this
unwanted info.


Regards
BrianB
====================================================
 
Back
Top