custom tables - layers

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

custom tables - layers

drfg2008
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