Does anybody know the syntax for doing ROW-TOTALS within an ACROSS:
like
ACROSS QUARTER ACROSS MONTH
and we want row-totals by quarter.
There's a way, buzzed about at Summit. But does anyone know???
thanks.
(can't use static syntax, time span varies)

I believe the systax is ON QUARTER ACROSSTOTAL
or ON YEAR , etc.

There is a subtotal on ACROSS in Dev Studio Report Painter.

It appears it works to some degree. I couldn't get more than one Across Total though. As well, the AS statement on the ACROSS-TOTAL doesn't seem to work.



-* ACROSS sortfield ACROSS-TOTAL [AS ' name'] [COLUMNS col1 AND col2 ...]

DEFINE FILE EMPLOYEE
HIRE_DATEX/YYMD = HIRE_DATE;
HIRE_Y/YY = HIRE_DATE;
HIRE_Q/YYQ = HIRE_DATE;
HIRE_M/YYM = HIRE_DATE;
END

TABLE FILE EMPLOYEE

SUM SALARY/P8C AS ''
ACROSS HIRE_Y AS '' ACROSS-TOTAL AS 'YEAR'
ACROSS HIRE_Q AS '' ACROSS-TOTAL AS 'QUARTER'
ACROSS HIRE_M AS ''
BY DEPARTMENT AS ''
END

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

no Gerry, that doesn't work.
i'm in 5.2.5 and ahalf.
What version is that supposed to work in?

ah... thanks Pietro.
I can't seem to get the AS phrase to work.
In the car file:
...this works
TABLE FILE CAR
SUM SALES ACROSS CAR ACROSS MODEL ACROSS-TOTAL AS 'fred'
BY COUNTRY
...but this does NOT work
TABLE FILE CAR
SUM SALES ACROSS CAR AS 'my car' ACROSS MODEL ACROSS-TOTAL AS 'fred'
BY COUNTRY
...the across total is titled 'TOTAL', not 'fred'
...it seems there's a bug, i'm in 525
..i've opened a case