Pivot table ranking

R

ReportSmith

Is there a way to 'rank' the rows in a pivot table (form)? For example, I
have a set of data:
Ice Cream
Total Sold
Flavor1 500
Flavor2 1000
Flavor3 200
etc...

I can see my best seller by sorting (descending) on the "Total Sold" field.
Is there any way (calculated field?) to put an actual ranking next to the
Flavor field? But when the Flavors change during the sort, the Ranking field
should remain static, so the ranking is new with new/updated data.

Can this be done within the Pivot Table or is there another (better?) way of
doing this (CrossTab query or report)?
 

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