SPSS20
using the layers function on custom tables:
[1] as soon as a variable is included in the layers the output shows no total any longer (it shows the first layer of the first variable). Is it possible to show the total without layer?
[2] is it possible to create a flexible filter as for example a time range without pre-defining this as a category?
Hope this is understandable. Here is the syntax.
Thx
* Custom Tables.
CTABLES
/FORMAT EMPTY=BLANK MISSING=''
/SMISSING VARIABLE
/VLABELS VARIABLES=country2 ChannelFinance NetRevenue Hold_PDS CalendarWeek month quarter day
betType
DISPLAY=LABEL
/TABLE country2 [C] BY ChannelFinance [C] > (NetRevenue [S][SUM] + Hold_PDS [S][SUM]) BY
(CalendarWeek [C] + month [C] + quarter [C] + day + betType [C])
/CATEGORIES VARIABLES=country2 ChannelFinance ORDER=A KEY=VALUE EMPTY=INCLUDE
/CATEGORIES VARIABLES=CalendarWeek month quarter day betType ORDER=A KEY=VALUE EMPTY=EXCLUDE.
Dr. Frank Gaeth