How to remove row in a crosstab when a specific column (maybe nested) in the crosstab has the measure value of 0, using OLAP data source

Resolving the problem

1. In the Report Studio, under the relevant query, create a new Data Item
2. In the expression definition of this new data item, put:

aggregate(currentMeasure within set [Column Data Item])

3. Save this data item as [Aggregate(Column)]
4. Create a new data item, this time in the expression definition, put something like this:

filter([Row Data Item], tuple([Aggregate(Column)],[Measure]) > 0)
and save it as [New Item].

[Row Data Item] is the data item for the crosstab row. Should the author use actual members for the row, it is recommended to create another additional Data Item to contain a set() function, which in turn contains each individual member that the author chooses. Use this data item in the filter() function above, and then use [New Item] as the crosstab row.

Attached below are report specs using Great Outdoors Company in 8.3 for nested and normal columns.