PivotTable Rank - Excel 2007

P

peter

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top