formula for adding crosstab labels with field name

[mgason]

Hi,
I have a crosstab with..
column head = machine name field.
row head = recipe field
cells show weight and batches required.

I want to add labels in the row head so that it shows the layout below, (Pounds and Batches just being text)..

{Recipe field} Pounds
Batches

crosstab would look like this

Machine 1 Machine 2
Cookies Pounds 100 300
Batches 10 10

Bread Pounds 900 300
Batches 18 6

How do I write a formula for the row head to show the field and text like this?

thanks
mark

 

[lbass]

Go to the customize style tab->summarized fields->check "show labels". Then modify the labels that result if they do not show 'Pounds' and 'Batches'.

-LB