swap groups upon selection

[mart10]

I am using CR2016 SP2

I have 4 groups

A
B
C
D

A&B are relevent together and C&D are relevent together.. I want to be able to select a parameter that will have the above group order or :

C
D
A
B

In other words flip the groups. What is best way to do this please?

 

[IanWaterman]

Create 4 group formula

@Group1
If Parameter1 = 'X' then Fieldc else FieldA

@Group2
If Parameter1 = 'X' then FieldD else FieldB
Repeat for other groups
Change formula and conditions as to meet your needs, Group on these formula instead of the original fields

Ian

 

[mart10]

Thanks this seemed to work fine