Highlighting Values in CrossTab

[JuliaFarber]

Hello,

I am usign cr10. I have regular crosstab. I would like to highlight a value in the row that is equal to row total.

Is it possible to do in crosstab?

Thank you.
Julia

 

[IanWaterman]

Don't think this is possible you will have use a manual cross tab.

There are many posts in this forum on how to build if you have not done so before.

Ian

 

[lbass]

How is your crosstab set up--row, column, and summary fields? What type of summary are you using?

-LB

 

[JuliaFarber]

I am using min as a summary. Here is the crosstab:

Vendor1 Vendor2 Vendor3
Type1 100
Type2 105
Type3 200 201

I would like to highlight min value in each row.
So for
Type1 - value for Vendor1 should be highlighted,
Type2 - value for Vendor2 should be highlighted,
Type3 - value for Vendor2 should be highlighted.

Thank you.
Julia

 

[lbass]

In your main report, insert a group on type. Then create a formula {@min}:

minimum({table.value},{table.type})

Add the minimum of this formula to your crosstab as the first summary, using minimum of {table.value} as your second summary.

In preview mode select the {@min} summary->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
numbervar minx := currentfieldvalue;
true;

Then select your second summary->right click->format field->suppress->x+2 and enter:
whileprintingrecords;
numbervar curr := currentfieldvalue;
false;

Then while this is still selected, go to the borders screen->color->background->x+2 and enter:

whileprintingrecords;
numbervar minx;
numbervar curr;
if curr = minx then
cryellow else
crnocolor

Resize the suppressed minimum summary to minimize its height.

-LB

 

[JuliaFarber]

Thanks. Worked perfectly.