Pivot Table Details

D

Dabears70

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

rdwj

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
 
Top