Peer Rank expression for selected value over all values in a dimension.

[Michael_Reese]

Hello,

I have a chart that has rank, peer rank, procedure code and net paid. 

The expectation is that when a providerid is selected, the rank will show that provider's products by net paid in descending order.  The rank field accurately reflects that.

The problem is with peer rank.  With a providerid selected, I need the peer rank field to show that selected providerid's ranking for that procedure over the enter universe of providers.

See below.  One provider is selected.  Rank shows the ranking of products for that provider.  Peer Rank should show his rank compared to all providers.

I've tried all of these expressions and none work.

//  aggr(Rank(sum(total  <ProcedureCode> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum(total <ProcedureCode, ProviderID> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum({<ProviderID=>} total <ProcedureCode, ProviderID> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum({<ProviderID=>} total <ProcedureCode> NetAmountPaid)), ProviderID)

//aggr(Rank(sum(total <ProcedureCode> NetAmountPaid)), ProviderID)

//aggr(Rank(sum(total <ProcedureCode> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum(total <ProviderID> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum({<ProviderID=>} total <ProviderID> NetAmountPaid)), ProcedureCode)

//aggr(Rank(sum(total ProcedureCode> NetAmountPaid)), ProviderID)

//aggr(Rank(sum(total <ProviderID> NetAmountPaid)), ProcedureCode)

//rank(aggr(sum({<ProviderID=>} total <ProcedureCode, ProviderID> NetAmountPaid), ProviderID), ProviderID)

//rank(sum({<ProviderID=>} total <ProcedureCode, ProviderID> NetAmountPaid), ProviderID)

//rank(aggr(sum({<ProviderID=>} total <ProcedureCode, ProviderID> NetAmountPaid), ProviderID))

//rank(aggr(sum({<ProviderID=>} total <ProcedureCode> NetAmountPaid), ProviderID))

//rank(aggr(sum({<ProviderID=>} total <ProcedureCode> NetAmountPaid), ProcedureCode))

//rank(aggr(sum({<ProviderID=>} <ProcedureCode> NetAmountPaid), ProcedureCode) )

//rank(aggr(sum({<ProviderID=>} NetAmountPaid), Specialty, ProcedureCode) )

//rank(aggr(sum(NetAmountPaid), ProviderID, ProcedureCode))

//rank(aggr(sum(NetAmountPaid), ProviderID, ProcedureCode))

//rank(sum(aggr(sum(NetAmountPaid), ProviderID, ProcedureCode)))

//rank(sum(aggr(sum(NetAmountPaid), ProviderID)))

//rank(aggr(sum(NetAmountPaid), ProviderID))

//rank(aggr(sum({<ProviderID=>} NetAmountPaid), ProviderID))

//rank(aggr(sum({<ProviderID=>} NetAmountPaid), ProcedureCode))

rank(sum({<ProviderID=>} NetAmountPaid) )

//rank( sum(aggr(sum(<ProviderID> NetAmountPaid), ProviderID)))

[swuehl · Accepted solution]

Mike,

maybe this solution I posted to another thread might help.

If not, please post a small sample file.