Forum Discussion

Gingerjeans88's avatar
Gingerjeans88
Helper IV
3 years ago
Solved

Excluding data from header totals in matrix

Hello all, 

 

I am building a report for a client and have shown their numbers in a matrix. They want to see number of licenses sold by category (Distributor, Suppliers etc), and then those categories are grouped into top-level headers by type. However, they don't want to include all of the component lines. 

For example, in the below table the Type 1 License totals (top level of matrix) should only include Type 1 License Distributor and Supplier totals, and not the 'Other' (apologies for layout but obviously can't add a matrix here and can't share my pbix). 

 

Obviously we could just add separate visuals and filter this out where needed, but this gets messy when cross-visual filtering.

 

How do we achieve this? Is there some smart option we have not thought of?

 

 October 2022November 2022December 2022
Type 1 License Totals100011001200
Type 1 License - Distributor8009001000
Type 1 License - Supplier200200200
Type 1 License - Other 150160160

3 Replies