Crystal Reports Crosstab Group Sort?

[janderson3]

I have a crosstab setup with years for the columns and I would like to sort the Top N based on the total from a specific year not from the grand total column. Is this possible, what have I been missing?

Thanks,
Jordan

 

[lbass]

Remove your column on year, and instead create one conditional formula per year like the following:

//{@2007}:
if year({table.date}) = 2007 then {table.amt}

Add each year conditional formula as a summary field in the crosstab, and in the customize style tab, select 'horizontal' and 'show labels' for summarized fields. Then select the crosstab->group sort and you will be able to choose any one of the summaries for your group sort.

You should always specify your CR version when posting.

-LB

 

[janderson3]

Worked like a charm, thanks.

-Jordan