2 independent Column Groups in report matrix?
Is it possible to get 2 independent column groups in a single matrix?
Let's take Adventure Works Cube as an example.
Row grouping: [Date].[Calendar year]
Columns: [Geography].[Country] and [Product].[Category]
Measure: [Sales Amount]
Idea is to see sales numbers for each year distributed by country and product category in a single row (empty cells possible).
Groups and subgroups isn't an option.
So is it possible with RDL and Reporting Services at all?
Regards, Andrei.
|