Non Aggregate Facts in Crosstab

[Birdie]

I have been trying to display a rank value in crosstab format, but contnue to see "blank" results. When the same data is represented in a columnar list format- no issues.

Essentially, what I want to see is "Year" across the top (columns) and "Client Name" as rows- with the Client's corresponding "Rank" intersected as facts.

            2009      2008
ClientA     237        221
ClientB       14        250

Any suggestions?

Thanks!
Birdie

[blom0344]

You need to set an aggregate against the measure in the body of the crosstab. In your case adding a minimum or maximum should not change the value of the rank I guess?