Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PivotTable Rank - Excel 2007
I have thousands or rows of data for spefic items with many many week and I
typically go through and sum up for latest 52 weeks, YTD, etc. I can then sort by whatever fact is appropriate and visually I can see which is best to worst, but would like to add a RANK within the table after the data has been summed. If I rank the "raw" data, I would sum many ranks and not come out with total #1, 2, 3, etc. Is is feasible to add/use a RANK in a PivotTable? I do not see any option and have seen similar steps in other suggestion, but each row is unique, so when summed #1 is still #1. Help is appreciated! -- Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007/2003 Pivottable compatibility | Excel Discussion (Misc queries) | |||
Excel 2007: Pivottable and Rank | Excel Worksheet Functions | |||
Excel 2007 PivotTable Question | Excel Worksheet Functions | |||
Pivottable columns multiply in excel 2007 | Excel Worksheet Functions | |||
Excel 2007 PivotTable and Chart | Excel Discussion (Misc queries) |