+ Reply to Thread
Results 1 to 2 of 2

pivot table

  1. #1
    Joe
    Guest

    pivot table

    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



  2. #2
    Jim Thomlinson
    Guest

    RE: pivot table

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

    Jim Thomlinson


    "Joe" wrote:

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1