pivot table

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hello
Can the data area in a pivot table just be a list of data, not a sum or
count etc - if so how can i instruct the table to show the data.

list of data eg
XX
AB
42
TOP
RAR


Cheers
 
Pivot tables are designed primarily for aggregating (consolidataing by sum or
average or...) data. The closest you will get is to toss one of the
dimensions (data items) in the data area (count, sum or whatever) and then
hide the data area. It is a little cheese but it works.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Defaults 1
Pivot Tables by Macro 2
Pivot Table Field based on two data area fields 3
Link Drop Down with Pivot Table 2
How to customize defaults in Pivot Table Values 1
Pivot Table static columns 4
Pivot Table 1

Back
Top