Rank based on user selected measure?

[patrickthatcher]

howdy.  I have a request for a ranking report where the user can select the measure to rank on.  I'm missing something because the rank = 1 for all records.  Can anyone see where I've gone wrong?

I have a Value prompt that is setup as such:
Parameter: RankField

Static choices:
Use: [Consolidated View].[Facts].[Confirmed Sales $]  Display: Confirmed Sales $
Use: [Consolidated View].[Facts].[Item Sold]               Display: Item Sold

Rank field:
Type: Data Item
Name: Rank
Expression: Rank(?RankField?)

I tried the Expression as Rank(ParamValue('RankField')) but this generated an error

tia

[navissar]

Try rank(#prompt('RankField','token')#)

[patrickthatcher]

Sweet it worked.  Thanks so much