A crosstab
report in Excel is called a pivot
report. Crosstabs provide a different view of data by showing values at the
intersection point of rows and columns. It provides a side-by-side comparison
of attributes while displaying data in a smaller area. This video shows how
to create a crosstab report, swap rows and columns, add a summary, and filter
data. How to validate, save and run the report is also demonstrated. This
video was recorded with IBM Cognos Analytics with Waston (11.2.2).