I am using crystal reports XI version and I have created a Percent bar chart based on the following fields:

 

1. On X-axis: fiscalmonth, OnTimeStatus

2. On Y-axis: Percentage of Count of OnTimeStatus

 

Now, I would like to sort the chart data based on the fiscalyear and fiscalperiod fields which are not included in the chart.

 

Any suggestions/ideas are greatly appreciated. I am pulling my hair from the past two days on this issue.

 

Thanks a million in advance.