Dividing results in multiple columns (Modified)

[former_member661280]

Hello,

I have the following temperatures:

Temperature (F) - LETTUCE48.6

Temperature (F) - THERMOKING 15.8

Temperature (F) - TOMATO 46.4

But I need to achieved something like this:

Temperatura (F) - LECHUGA Temperatura (F) - THERMOKING Temperatura (F) - TOMATE

48.6 15.8 46.4

In other words, need to separate every temperature in columns.

Any help?

[mhmohammed]

Hi Rosario,

Simply, create a Cross tab with that field running across on top, so it will create a column for each of those values.

If that doesn't work for your, you'll have to create variables as below

LECHUGA 48.6 = [Measure] where ([Object]="LECHUGA 48.6")
and so on.

Thanks,
Mahboob Mohammed