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: