Grouping

[LDickenson]

Hi

I need to write a report as follow:-

OBJECTIVE 1 GREEN
OBJECTIVE 2 AMBER
OBJECTIVE 3 RED
OBJECTIVE 4 GREEN
OBJECTIVE 5 AMBER
OBJECTIVE 6 RED
OBJECTIVE 7 GREEN


I then need the report to group as follows

GREEN

OBJECTIVE 1
OBJECTIVE 4
OBJECTIVE 7

AMBER

OBJECTIVE 2 AMBER
OBJECTIVE 5 AMBER


RED


OBJECTIVE 3 RED
OBJECTIVE 6 RED


Can anyone help with this please?

Thanks

Lisa

 

[hilfy]

Add a group on the color field and sort by objective. This should be pretty straight forward....

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[LDickenson]

Thanks

Already tried, tried all sorts for some reason it will not sort the colours in order, even tried formulas to sort the colours.

Thanks

Lisa

 

[hilfy]

Right-click in the grey area to the left of the group header section and select "Change Group". Where it says "In ascending order", change it to "In specified order". Then select your colors in the order you want them to appear.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com