Group X Axis label - need it to be the Group Label

[swhitten]

In Group Expert - Options - Options, I selected Customize Group Name Field, and I have a formula as Group Name. The custom group name shows on the report as the label for the group.

But when I create a chart, the actual group value is showing up as the X Axis label instead of the Group Name field.

I have two reports that are very similar. This is only happening on one of them. On the other report, the customized Group Name field shows as the X Axis label. I cannot find any differences between the fields and the chart labels.

Any idea how I can get the chart to show my custmized group name field? Thanks!

 

[swhitten]

I have determined the difference between the two reports.

Report 1, which works correctly and shows me my custom group name for the Group X Axis Labels, has only one set of data. On the data tab of the Chart Expert, I go to Group, and I see "on change of @value show sum of @sales. When i go to Advanced tab, there is nothing there.

Report 2, which does NOT work correctly - has group value instead of custom group name, has TWO sets of data. On the Data tab of the Chart expert, I go to Advanced, and I see "on change of @value show sum of @sales and also sum of @salessecondary." If I make it have only one data set and make it be on the Group tab instead of on the Advanced tab, my labels show properly.

so to further clarify my question, how can I get custom group name to show when I have two sets of data?