Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 1st 07, 01:40 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 19
Default 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   Report Post  
Old 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
Default 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





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
How to add ranking in pivot table? clarice Excel Discussion (Misc queries) 0 March 19th 07 12:50 PM
Data Items Values In Pivot Tables/Charts Steen Excel Discussion (Misc queries) 2 November 5th 06 09:00 PM
Pivot tables with zero/null values Todd1 Excel Discussion (Misc queries) 4 March 28th 06 12:45 PM
Supress Zero Values on Pivot Tables AROR Excel Discussion (Misc queries) 0 April 21st 05 01:23 AM
ranking an row of values Wazooli Excel Worksheet Functions 4 December 13th 04 10:09 PM


All times are GMT +1. The time now is 10:32 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017