Pivot Table Details

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dabears70 - 20 Dec 2007 16:03 GMT

Is there a way to have the details of each field show instead of a count or
sum. For instance, in a particular field the there may be detail that would
normally show such as TRUE or FALSE. When I drag this field it populates with
a number instead of the True or False. Is there a way to get in to show the
TRUE or FALSE details?

Also I would like the the details to be listed under the column fields as
apposed to row fields
For Example
I would like to list the list of all companies in the Row fields and then
have a list of column field showing the location of the each company and the
products used at the company.

Can someone help me with this?

Thank you,

Signature

Nick

Reply to this Message

rdwj - 20 Dec 2007 16:48 GMT

nick,
depends on what you want to do....
If you drag your "True/False" indicator to the data field (ie the middle of
the pivot) then you either sum or count them. If you want your data grouped
by True or False, drag it to the row.... Alternatively, drag it to the page
field to either show true of false.

To get a pivot with company's with location and products, the question is
what you want where and how your input looks. If you have an input table with
Company, product, location in three columns, I would argue that you could put
Company and location in the rows, product in the top and count of location as
data.

Regards, rdwj

> Is there a way to have the details of each field show instead of a count or
> sum. For instance, in a particular field the there may be detail that would
[quoted text clipped - 12 lines]
>
> Thank you,

Reply to this Message