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)?
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)?