Specified order in chart

98 Views

Post Author: tinaboltzius

CA Forum: Charts and Graphs

Hi,

I am using a Bar chart in Crystal that shows a person's financial holdings, divided into 3 different groups (groups). Each group can contain different security types (names). One kind of security can exist in different groups. In the chart settings there are two fields (group, name) in the "On change of" list on the Data tab.

The groups are sorted in Ascending order and the names use a Specified order. The specified order works fine for in the first group, but not in the last of the three groups.

Example:

Sortorder: Equities, Bonds, Derivatives, Structured products, Others, Pension products

In group (bar) 1: Equities, Bonds, Structured Products

In group (bar) 2: Derivatives

In group (bar) 3: Pension products, Equities <--- Wrong order, should be the opposite

Does anyone know how to fix this? Is it a bug?

Let me know if you want more details and I can add pictures.

Thanks in advance!

Best Regards, Tina