One of my issues was to develop a report with a grouping column at the right like that:
a group on ProductCategory and ProductSubcategory
For this, we have to develop a report and group only on ProductCategory (The first column).
And for grouping on Product Subcategory column, we have to apply a formula so as to hide duplicated lines.
Click on Product Subcategory column, and select Value properties then select <Expression…>
On expression, write the following code:
=Iif(Fields!ProductCategory.Value= Previous(Fields!ProductCategory.Value) AND
Fields!ProductSubcategory.Value= Previous(Fields!ProductSubcategory.Value) , ” ” ,Fields!ProductSubcategory.Value)
And here is the result: