I have a straight forward report. It shows months trended ACROSS with a column for Actual, Budget and Prior underneath each month. For a given year, I have 36 columns.

They want to have 12 months across with a row for Actual, a row for Budget and a row for Prior.

In an Excel pivot I would simply drag the 'data' area down to a vertical veiw.

Can I get this format in WebFocus with out creating a variable: Vintage with values of ACtual, Budget and Prior and defining just ONE measure: AMOUNT?

I think that would require me to do a couple APPENDS making a very straight forward process a bit more cumbersome.

It there a trick or something in the GUI I am missing?


Current code:

TABLE FILE TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT
SUM
TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.ACTVISITS AS 'Actual,Visits'
TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.BUDGVISITS AS 'Budget,Visits'
TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.PRIORVISITS AS 'Prior,Visits,'
ACROSS LOWEST TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.PERIOD
WHERE ( TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.INPATOUTPATFLAG EQ 'O' ) AND ( J0.TBLMSTR_BOGSTRUCTURE.ROLLUP_2 EQ 'Original Practices' ) AND ( J0.TBLMSTR_BOGSTRUCTURE.ROLLUP_3 NE 'Emergency Medicine' ) OR ( TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.TBLMSTR_BOG_VISITSINPATIENTOUTPATIENT.INPATOUTPATFLAG EQ 'O' ) AND ( J0.TBLMSTR_BOGSTRUCTURE.ROLLUP_2 EQ 'Non-Original Practices' ) AND ( J0.TBLMSTR_BOGSTRUCTURE.ROLLUP_3 EQ 'Clinics' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
.
.
.

This message has been edited. Last edited by: <Kathryn Henning>,

Robert,
Did you try using OVER:

  
TABLE FILE CAR
SUM RCOST OVER DCOST OVER SALES
ACROSS SEATS
BY COUNTRY
END

***CLOSED

AWESOME!!!!
Thanks!