Auto Orderiing in Chart with Cyclic Groups

[#1]

I have a Chart (table) with Cyclic group witch looks like this:

Grouped field 1	Name	Price
1	A	12
2	B	15

And if I change the group value

Grouped field 2	Name	Price
T	A	20
R	B	7

I'd like to automatically sort by Name for Grouped field 1 selected and

I'd like to automatically sort by Price Desc for Grouped field 2 selected.

Is it possible?

[jonathandienst]

Hi

From Document Properties | Groups, select the group in the Groups box. Then click Edit. Now click on Sort Orders. Select the first field and define the sort properties. Then select the second field and define the sort properties, and so on. Click OK (3 times) to save.

HTH

Jonathan

[#3]

You can use "Expression" in "order" tab, setting the currently shown field. You can know what's the current field of a group with GetCurrentField(groupname) function.

Formula should be similar to:

=GetCurrentField(groupname)

you can finally specify Ascending or Descending....

Regards,

f.