Remember Me?

#1
May 1st 07, 01:40 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Oct 2006 Posts: 19
Pivot Tables - Ranking Values

Hello.

I'm using Excel 2007

I have a pivot table that returns values like:

Object Channel 1 Channel 2 Channel 3
Name of O1 50% 33% 75%
Name of O2 12% 58% 99%

The Channels are actually measures of Effectiveness.

I want to rank these percentages so that I can see that for Object 1 that
Channel 3 is the highest, Channel 1 is next, and Channel 2 is lowest.
Something like:

Object Channel 1 Channel 2 Channel 3
Title of O1 2 3 1
Title of O2 3 2 1

When I try to add a calculated field, Effectiveness appears as a field but
not each individual channel.

Seems like I should be able to use a Rank function (or something like it)
within the pivot table, but I can't seem to figure it out...

Any help is appreciated.

Thanks.
--
Jeff

#2
May 1st 07, 03:44 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 5,441
Pivot Tables - Ranking Values

Jeff,

You could use Rank formulas based on your PT values, but otherwise, no.

HTH,
Bernie
MS Excel MVP

"Jeff Reese" wrote in message
news
Hello.

I'm using Excel 2007

I have a pivot table that returns values like:

Object Channel 1 Channel 2 Channel 3
Name of O1 50% 33% 75%
Name of O2 12% 58% 99%

The Channels are actually measures of Effectiveness.

I want to rank these percentages so that I can see that for Object 1 that
Channel 3 is the highest, Channel 1 is next, and Channel 2 is lowest.
Something like:

Object Channel 1 Channel 2 Channel 3
Title of O1 2 3 1
Title of O2 3 2 1

When I try to add a calculated field, Effectiveness appears as a field but
not each individual channel.

Seems like I should be able to use a Rank function (or something like it)
within the pivot table, but I can't seem to figure it out...

Any help is appreciated.

Thanks.
--
Jeff

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post clarice Excel Discussion (Misc queries) 0 March 19th 07 12:50 PM Steen Excel Discussion (Misc queries) 2 November 5th 06 09:00 PM Todd1 Excel Discussion (Misc queries) 4 March 28th 06 12:45 PM AROR Excel Discussion (Misc queries) 0 April 21st 05 01:23 AM Wazooli Excel Worksheet Functions 4 December 13th 04 10:09 PM

All times are GMT +1. The time now is 12:36 PM.