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