pivot table sorting

Can you give an example of how your pivot table appears now, and how
you'd like it to appear?

ushah wrote:
> I have file for different supplies, and other one for accout description
> (that supplies were used under). Most supplies only appears under one account
> only but there are some supplies that were used for more than one account
> description. How can I just sort the supplies description so that it only
> shows or it shows the one that were used for more than one account
> description?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Sure,

This is what it looks like now,
Description of item
Description of Account
TAPE: DOUBLE SIDED REFLECTIVE: Office Supplies
TAPE: DOUBLE SIDED REFLECTIVE: Sum

SPATULA: FISHER SCIENTIFIC #14 Office Supplies
Office Supplies

OFFICE SUPPLIES,CLEANER: FORD Equip Non-Proj.Main-Mach. &
Office Supplies
OFFICE SUPPLIES,CLEANER: FORD Sum

So, I have 3 different item description Tape, Spatula & Office supplies
cleaner. Out of that first two items only falls under one account description
which is Office supply but the last and third item (Cleaner) falls under
office supplies and Non-Proj.Main-Mach. description.

I have about 1800 total items out of that may be 50 items used more than one
account, and I wanted to find those items and list it by itself. Is it
possible to do that? if so how?
and thank you for your reply.


"ushah" wrote:

> I have file for different supplies, and other one for accout description
> (that supplies were used under). Most supplies only appears under one account
> only but there are some supplies that were used for more than one account
> description. How can I just sort the supplies description so that it only
> shows or it shows the one that were used for more than one account
> description?

You could add a column to the source table, and calculate which items
contain an "&". For example:

=IF(ISNUMBER(SEARCH("&",B2)),"Yes","No")

Then, add that field to the pivot table page area, and select "Yes" from
the dropdown list of items.

ushah wrote:
> Sure,
>
> This is what it looks like now,
> Description of item
> Description of Account
> TAPE: DOUBLE SIDED REFLECTIVE: Office Supplies
> TAPE: DOUBLE SIDED REFLECTIVE: Sum
>
> SPATULA: FISHER SCIENTIFIC #14 Office Supplies
> Office Supplies
>
> OFFICE SUPPLIES,CLEANER: FORD Equip Non-Proj.Main-Mach. &
> Office Supplies
> OFFICE SUPPLIES,CLEANER: FORD Sum
>
> So, I have 3 different item description Tape, Spatula & Office supplies
> cleaner. Out of that first two items only falls under one account description
> which is Office supply but the last and third item (Cleaner) falls under
> office supplies and Non-Proj.Main-Mach. description.
>
> I have about 1800 total items out of that may be 50 items used more than one
> account, and I wanted to find those items and list it by itself. Is it
> possible to do that? if so how?
> and thank you for your reply.
>
>
> "ushah" wrote:
>
>
>>I have file for different supplies, and other one for accout description
>>(that supplies were used under). Most supplies only appears under one account
>>only but there are some supplies that were used for more than one account
>>description. How can I just sort the supplies description so that it only
>>shows or it shows the one that were used for more than one account
>>description?
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I have file for different supplies, and other one for accout description
(that supplies were used under). Most supplies only appears under one account
only but there are some supplies that were used for more than one account
description. How can I just sort the supplies description so that it only
shows or it shows the one that were used for more than one account
description?

Can you give an example of how your pivot table appears now, and how
you'd like it to appear?

ushah wrote:
> I have file for different supplies, and other one for accout description
> (that supplies were used under). Most supplies only appears under one account
> only but there are some supplies that were used for more than one account
> description. How can I just sort the supplies description so that it only
> shows or it shows the one that were used for more than one account
> description?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Sure,

This is what it looks like now,
Description of item
Description of Account
TAPE: DOUBLE SIDED REFLECTIVE: Office Supplies
TAPE: DOUBLE SIDED REFLECTIVE: Sum

SPATULA: FISHER SCIENTIFIC #14 Office Supplies
Office Supplies

OFFICE SUPPLIES,CLEANER: FORD Equip Non-Proj.Main-Mach. &
Office Supplies
OFFICE SUPPLIES,CLEANER: FORD Sum

So, I have 3 different item description Tape, Spatula & Office supplies
cleaner. Out of that first two items only falls under one account description
which is Office supply but the last and third item (Cleaner) falls under
office supplies and Non-Proj.Main-Mach. description.

I have about 1800 total items out of that may be 50 items used more than one
account, and I wanted to find those items and list it by itself. Is it
possible to do that? if so how?
and thank you for your reply.


"ushah" wrote:

> I have file for different supplies, and other one for accout description
> (that supplies were used under). Most supplies only appears under one account
> only but there are some supplies that were used for more than one account
> description. How can I just sort the supplies description so that it only
> shows or it shows the one that were used for more than one account
> description?

You could add a column to the source table, and calculate which items
contain an "&". For example:

=IF(ISNUMBER(SEARCH("&",B2)),"Yes","No")

Then, add that field to the pivot table page area, and select "Yes" from
the dropdown list of items.

ushah wrote:
> Sure,
>
> This is what it looks like now,
> Description of item
> Description of Account
> TAPE: DOUBLE SIDED REFLECTIVE: Office Supplies
> TAPE: DOUBLE SIDED REFLECTIVE: Sum
>
> SPATULA: FISHER SCIENTIFIC #14 Office Supplies
> Office Supplies
>
> OFFICE SUPPLIES,CLEANER: FORD Equip Non-Proj.Main-Mach. &
> Office Supplies
> OFFICE SUPPLIES,CLEANER: FORD Sum
>
> So, I have 3 different item description Tape, Spatula & Office supplies
> cleaner. Out of that first two items only falls under one account description
> which is Office supply but the last and third item (Cleaner) falls under
> office supplies and Non-Proj.Main-Mach. description.
>
> I have about 1800 total items out of that may be 50 items used more than one
> account, and I wanted to find those items and list it by itself. Is it
> possible to do that? if so how?
> and thank you for your reply.
>
>
> "ushah" wrote:
>
>
>>I have file for different supplies, and other one for accout description
>>(that supplies were used under). Most supplies only appears under one account
>>only but there are some supplies that were used for more than one account
>>description. How can I just sort the supplies description so that it only
>>shows or it shows the one that were used for more than one account
>>description?
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html