Download Advanced Crosstab

Table of Contents
Categories ......................................................................................................................................................................4
Show all .....................................................................................................................................................................4
Search............................................................................................................................................................................5
Filtering ..........................................................................................................................................................................6
Other Advanced Features ..............................................................................................................................................7
Highlight Data ............................................................................................................................................................ 7
Colour Tiles................................................................................................................................................................ 8
Calculations ............................................................................................................................................................... 9
Calculation Function ............................................................................................................................................ 10
Survey Display Order............................................................................................................................................... 11
Sort: Advanced sorting ........................................................................................................................................... 11
CPT Calculation ........................................................................................................................................................... 12
Arithmetic Operators .................................................................................................................................................... 13
The “PLUS” operator ............................................................................................................................................... 13
The “minus” operator ............................................................................................................................................... 14
The “multiply” operator ............................................................................................................................................. 14
The “divide” operator ............................................................................................................................................... 14
Relational Operators .................................................................................................................................................... 15
Coding - Logical Operators .......................................................................................................................................... 16
The “And” Operator.................................................................................................................................................. 16
The “Or” Operator .................................................................................................................................................... 17
The “Not” Operator .................................................................................................................................................. 18
Combining Operators............................................................................................................................................... 18
Priority ................................................................................................................................................................. 18
Volume Coding............................................................................................................................................................. 19
Card, Column, Punch .......................................................................................................................................... 20
MNEMONICS ...................................................................................................................................................... 20
Weightings ................................................................................................................................................................... 21
Population Weight.................................................................................................................................................... 21
Household Weight ................................................................................................................................................... 21
Household Decision Maker Weight .......................................................................................................................... 21
Household Purchaser Weight .................................................................................................................................. 21
Radio Coding ............................................................................................................................................................... 22
Week Cumes ........................................................................................................................................................... 22
Day Cumes .............................................................................................................................................................. 22
Average Quarter Hours ............................................................................................................................................ 23
Page 2