Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 6th 10, 02:15 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 48
Default pivot table sorting

Hello, I have data that includes alot of fileds but my pivot table has
PO, PO line, Vendor, and value. I need to sort the top 10 values by PO
and line item. I cannot seem to figure it out. Can someone help?

Thanks

  #2   Report Post  
Old January 6th 10, 04:41 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default pivot table sorting

Pat you do not state what your PO and PO Lines are so the amount of help I
can provide you is limited.

I have put a file up for you at:-

http://www.pierrefondes.com/

It is item number 30 towards the top of my home page (at the top at the
moment).

In EXCEL 2007:-

I will give explanation by way of reference to a file called pivot_top_ten.

In cell F16 there is a drop down button. Click this. Select Value Filters
then Top 10.

Pop up should appear with four fields:-

Show
Top 10 Items Sum of Value

Hit OK.

Top ten items (by Vendor) should now appear in the Pivot Table.

In the example that I have done Unilever does not appear in the Top Ten
which is correct.

If my comments have helped please hit Yes.

Thanks.


"pat67" wrote:

Hello, I have data that includes alot of fileds but my pivot table has
PO, PO line, Vendor, and value. I need to sort the top 10 values by PO
and line item. I cannot seem to figure it out. Can someone help?

Thanks
.

  #3   Report Post  
Old January 6th 10, 04:55 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 48
Default pivot table sorting

On Jan 6, 11:41*am, trip_to_tokyo wrote:
Pat you do not state what your PO and PO Lines are so the amount of help I
can provide you is limited.

I have put a file up for you at:-

http://www.pierrefondes.com/

It is item number 30 towards the top of my home page (at the top at the
moment).

In EXCEL 2007:-

I will give explanation by way of reference to a file called pivot_top_ten.

  #4   Report Post  
Old January 6th 10, 05:59 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default pivot table sorting

PO PO Line Vendor Sum of Value
1234 1 X $100

For PO and PO Line are these number or text fields?

What ranges do they cover? So, for example, does PO Line run from 1 to 1000?
How is the data for PO Column (Field) structured? What range does it cover?

"pat67" wrote:

On Jan 6, 11:41 am, trip_to_tokyo wrote:
Pat you do not state what your PO and PO Lines are so the amount of help I
can provide you is limited.

I have put a file up for you at:-

http://www.pierrefondes.com/

It is item number 30 towards the top of my home page (at the top at the
moment).

In EXCEL 2007:-

I will give explanation by way of reference to a file called pivot_top_ten.

In cell F16 there is a drop down button. Click this. Select Value Filters
then Top 10.

Pop up should appear with four fields:-

Show
Top 10 Items Sum of Value

Hit OK.

Top ten items (by Vendor) should now appear in the Pivot Table.

In the example that I have done Unilever does not appear in the Top Ten
which is correct.

If my comments have helped please hit Yes.

Thanks.



"pat67" wrote:
Hello, I have data that includes alot of fileds but my pivot table has
PO, PO line, Vendor, and value. I need to sort the top 10 values by PO
and line item. I cannot seem to figure it out. Can someone help?


Thanks
.- Hide quoted text -


- Show quoted text -


I know that part here is the issue. PO is Purchase Order, PO Line is
the Purchase Order Line item. Here is what my pivot table looks like

PO PO Line Vendor Sum of Value

1234 1 X $100

The issue is I can only sort by 1 column and I need to sort by 2. In
other words, I can get the top 10 for PO or PO line or Vendor. I need
by PO and PO line so the buyers can see what's the largest dollar
values. I concatenated the data into 1 field to make it work, but I
was wondering how to do it without concatenating data
.

  #5   Report Post  
Old January 6th 10, 07:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 48
Default pivot table sorting

On Jan 6, 12:59*pm, trip_to_tokyo wrote:
PO * * PO Line * *Vendor * Sum of Value
1234 * * *1 * * * * * * * X * * * * $100

For PO and PO Line are these number or text fields?

What ranges do they cover? So, for example, does PO Line run from 1 to 1000?
How is the data for PO Column (Field) structured? What range does it cover?



"pat67" wrote:
On Jan 6, 11:41 am, trip_to_tokyo wrote:
Pat you do not state what your PO and PO Lines are so the amount of help I
can provide you is limited.


I have put a file up for you at:-


http://www.pierrefondes.com/


It is item number 30 towards the top of my home page (at the top at the
moment).


In EXCEL 2007:-


I will give explanation by way of reference to a file called pivot_top_ten.


In cell F16 there is a drop down button. Click this. Select Value Filters
then Top 10.


Pop up should appear with four fields:-


Show
Top 10 Items Sum of Value


Hit OK.


Top ten items (by Vendor) should now appear in the Pivot Table.


In the example that I have done Unilever does not appear in the Top Ten
which is correct.


If my comments have helped please hit Yes.


Thanks.


"pat67" wrote:
Hello, I have data that includes alot of fileds but my pivot table has
PO, PO line, Vendor, and value. I need to sort the top 10 values by PO
and line item. I cannot seem to figure it out. Can someone help?


Thanks
.- Hide quoted text -


- Show quoted text -


I know that part here is the issue. PO is Purchase Order, PO Line is
the Purchase Order Line item. Here is what my pivot table looks like


PO * * PO Line * *Vendor * Sum of Value


1234 * * *1 * * * * * * * X * * * * $100


The issue is I can only sort by 1 column and I need to sort by 2. In
other words, I can get the top 10 for PO or PO line or Vendor. I need
by PO and PO line so the buyers can see what's the largest dollar
values. I concatenated the data into 1 field to make it work, but I
was wondering how to do it without concatenating data
.- Hide quoted text -


- Show quoted text -


numbered fields. PO is 8 digits and PO Line is 5 and will have 0's in
from i.e PO 46556789 Line 01230

like I said, i concatenated that to 46556789/01230 an was able to get
what I needed. My question was if it was possible without having to do
that


  #6   Report Post  
Old January 6th 10, 08:01 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default pivot table sorting

Hi Pat, I did have a further look at this and, as far as I can see, you
cannot do what you are trying to do in a Pivot Table.

There might be better ways to do this but not in a Pivot Table; for example,
in EXCEL 2007, using Data / Sort on two levels and introducing Subtotals (in
the Outline group).

Without being able to see the data, or how it is structured, makes things
difficult.

I also played aroud with Filters but I don't think that that will give you
what you want either.


"pat67" wrote:

On Jan 6, 12:59 pm, trip_to_tokyo wrote:
PO PO Line Vendor Sum of Value
1234 1 X $100

For PO and PO Line are these number or text fields?

What ranges do they cover? So, for example, does PO Line run from 1 to 1000?
How is the data for PO Column (Field) structured? What range does it cover?



"pat67" wrote:
On Jan 6, 11:41 am, trip_to_tokyo wrote:
Pat you do not state what your PO and PO Lines are so the amount of help I
can provide you is limited.


I have put a file up for you at:-


http://www.pierrefondes.com/


It is item number 30 towards the top of my home page (at the top at the
moment).


In EXCEL 2007:-


I will give explanation by way of reference to a file called pivot_top_ten.


In cell F16 there is a drop down button. Click this. Select Value Filters
then Top 10.


Pop up should appear with four fields:-


Show
Top 10 Items Sum of Value


Hit OK.


Top ten items (by Vendor) should now appear in the Pivot Table.


In the example that I have done Unilever does not appear in the Top Ten
which is correct.


If my comments have helped please hit Yes.


Thanks.


"pat67" wrote:
Hello, I have data that includes alot of fileds but my pivot table has
PO, PO line, Vendor, and value. I need to sort the top 10 values by PO
and line item. I cannot seem to figure it out. Can someone help?


Thanks
.- Hide quoted text -


- Show quoted text -


I know that part here is the issue. PO is Purchase Order, PO Line is
the Purchase Order Line item. Here is what my pivot table looks like


PO PO Line Vendor Sum of Value


1234 1 X $100


The issue is I can only sort by 1 column and I need to sort by 2. In
other words, I can get the top 10 for PO or PO line or Vendor. I need
by PO and PO line so the buyers can see what's the largest dollar
values. I concatenated the data into 1 field to make it work, but I
was wondering how to do it without concatenating data
.- Hide quoted text -


- Show quoted text -


numbered fields. PO is 8 digits and PO Line is 5 and will have 0's in
from i.e PO 46556789 Line 01230

like I said, i concatenated that to 46556789/01230 an was able to get
what I needed. My question was if it was possible without having to do
that
.

  #7   Report Post  
Old January 6th 10, 08:19 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 48
Default pivot table sorting

On Jan 6, 3:01*pm, trip_to_tokyo wrote:
Hi Pat, I did have a further look at this and, as far as I can see, you
cannot do what you are *trying to do in a Pivot Table.

There might be better ways to do this but not in a Pivot Table; for example,
in EXCEL 2007, using Data / Sort on two levels and introducing Subtotals (in
the Outline group).

Without being able to see the data, or how it is structured, makes things
difficult.

I also played aroud with Filters but I don't think that that will give you
what you want either.



"pat67" wrote:
On Jan 6, 12:59 pm, trip_to_tokyo wrote:
PO * * PO Line * *Vendor * Sum of Value
1234 * * *1 * * * * * * * X * * * * $100


For PO and PO Line are these number or text fields?


What ranges do they cover? So, for example, does PO Line run from 1 to 1000?
How is the data for PO Column (Field) structured? What range does it cover?


"pat67" wrote:
On Jan 6, 11:41 am, trip_to_tokyo wrote:
Pat you do not state what your PO and PO Lines are so the amount of help I
can provide you is limited.


I have put a file up for you at:-


http://www.pierrefondes.com/


It is item number 30 towards the top of my home page (at the top at the
moment).


In EXCEL 2007:-


I will give explanation by way of reference to a file called pivot_top_ten.


In cell F16 there is a drop down button. Click this. Select Value Filters
then Top 10.


Pop up should appear with four fields:-


Show
Top 10 Items Sum of Value


Hit OK.


Top ten items (by Vendor) should now appear in the Pivot Table.


In the example that I have done Unilever does not appear in the Top Ten
which is correct.


If my comments have helped please hit Yes.


Thanks.


"pat67" wrote:
Hello, I have data that includes alot of fileds but my pivot table has
PO, PO line, Vendor, and value. I need to sort the top 10 values by PO
and line item. I cannot seem to figure it out. Can someone help?


Thanks
.- Hide quoted text -


- Show quoted text -


I know that part here is the issue. PO is Purchase Order, PO Line is
the Purchase Order Line item. Here is what my pivot table looks like


PO * * PO Line * *Vendor * Sum of Value


1234 * * *1 * * * * * * * X * * * * $100


The issue is I can only sort by 1 column and I need to sort by 2. In
other words, I can get the top 10 for PO or PO line or Vendor. I need
by PO and PO line so the buyers can see what's the largest dollar
values. I concatenated the data into 1 field to make it work, but I
was wondering how to do it without concatenating data
.- Hide quoted text -


- Show quoted text -


numbered fields. PO is 8 digits and PO Line is 5 and will have 0's in
from i.e PO 46556789 * *Line 01230


like I said, i concatenated that to 46556789/01230 an was able to get
what I needed. My question was if it was possible without having to do
that
.- Hide quoted text -


- Show quoted text -


I figured that was the case. Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table sorting Patty Slowik Excel Discussion (Misc queries) 1 August 25th 09 03:21 PM
Sorting a Pivot Table cware Excel Worksheet Functions 2 August 26th 08 12:27 AM
Pivot table sorting Compass Rose Excel Discussion (Misc queries) 2 July 11th 08 08:56 PM
Sorting / Pivot Table Rebecca New Users to Excel 1 June 8th 06 05:34 AM
Pivot Table sorting TomHinkle Excel Discussion (Misc queries) 5 June 2nd 05 09:14 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017