Hiding columns in crosstabs
Users want to see sales figures by periods and order method. We need to show monthly sales and the yearly total sales. The year should be shown in the Year total row and not as a separate column.
Create a crosstab report with Sales fact / Quantity as a measure. Drag Time/Year and Month on rows, Order method / Order method type on column as shown in the following screenshot, and create aggregation on measure:
Add a total for the Month and Order method type then define appropriate sorting if required.
How to do it...
In this recipe, we want to hide the year from the crosstab and show it only in the report as a ...