SPSS Reporting and “OLAP cubes”

Here we list our experience with the Reports tab in SPSS:

From SPSS > Choose Analyze > Reporting > OLAP Cube:

Choose the continuous and grouping variables as follows, and choose the statistical ( summary) functions for each continuous variable, default is SUM:

Result will be as follows:

Unfortunately nothing like the Excel pivot tables.

We check the summary from Same Reports tab: It has similar output of tables not pivot tables and not interactive:

These are the options for Summaries in Rows and in the background is the results for these values:

Leave a Reply

Your email address will not be published. Required fields are marked *