Forum Discussion
Separated Two Row Headers in Matrix
Hi peterpan
Use one Matrix with Distributor then Outlet as rows and turn Stepped layout off. In the model, link DimDate and DimDistributor to both fact tables, and link DimOutlet only to FctDistributorSales. Keep Distributor subtotals on and Outlet subtotals off. Create measures that switch by level using ISINSCOPE so Outlet rows read from FctDistributorSales and Distributor and Grand Total read from FactMainSales,for example Collection A = IF(ISINSCOPE(DimOutlet[Outlet]), SUM(FctDistributorSales[CollectionA]), SUM(FactMainSales[CollectionA])); do the same for Collection B and set Total = A + B. If you want a second subheader after the first two columns, add a disconnected Band table in Columns and return values only for the matching band.
Thanks for the input. This is similar but can we create second subheader column after first two values of Collections? Also, it would be beneficial since the outlet values will have a subtotal which won't match with distributor sales value
Hi peterpan
Use one Matrix with Distributor then Outlet as rows and turn Stepped layout off. In the model, link DimDate and DimDistributor to both fact tables, and link DimOutlet only to FctDistributorSales. Keep Distributor subtotals on and Outlet subtotals off. Create measures that switch by level using ISINSCOPE so Outlet rows read from FctDistributorSales and Distributor and Grand Total read from FactMainSales,for example Collection A = IF(ISINSCOPE(DimOutlet[Outlet]), SUM(FctDistributorSales[CollectionA]), SUM(FactMainSales[CollectionA])); do the same for Collection B and set Total = A + B. If you want a second subheader after the first two columns, add a disconnected Band table in Columns and return values only for the matching band.