Rank, Aggr questions

[mikecrengland]

At least, that's what I think I need.

We have field marketing reps that visit retail locations and report on purchase decisions. I want to report on the top three responses by month:

Purchase Reasons	Jan	Feb	Mar
Top Reason	Battery Life	Battery Life	Color
Second Reason	Brand	Color	Brand
Third Reason	Color	Brand	Battery Life

I though I could use valuelist() to create the rows and an expression like:

=If(

  Rank(Aggr(Count(DISTINCT CallReport.Key),DecisionReason)) = 1,

  DecisionReason)

to get the 'Top Reason' row.

To test it, I put that into a text object and get nothing back.

Am I close?

[jpapador · Accepted solution]

Try:

If(Aggr(Rank(Count(CallReport.Key)), DecisionReason) = 1, DecisionReason)

If you are doing it in a text box put an only around it,

Only(If(Aggr(Rank(Count(CallReport.Key)), DecisionReason) = 1, DecisionReason))

[mikecrengland]

Thank you!