Hi,
I am new to WebFOCUS and I'm looking for some help on how i can get my metrics to display down the side rather than going across the top?

So instead of displaying:

CAR DEALER_COST RETAIL_COST SALES
ALFA ROMEO 16,235 19,565 30200
AUDI 5,063 5,970 7800
BMW 49,500 58,762 80390

I would like:

ALFA ROMEO AUDI BMW
DEALER_COST 16,235 5,063 49,500
RETAIL_COST 19,565 5,970 58,762
SALES 30,200 7,800 80,390

I mostly work in the GUI, so if there is a way to do it there that would be best, but any help would be appreciated.

Thanks,
Ryan

This message has been edited. Last edited by: rmcvicker,

Ryan,

The code you want is

  
SUM 
     DEALER_COST OVER 
     RETAIL_COST OVER 
     SALES
ACROSS CAR

In the GUI, you r-click the field, select options and in "Options" under "General" you find "New line (OVER)"

Good luck!

Exactly what i needed! Thanks Daniel!