Forum Discussion
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 2022 | November 2022 | December 2022 | |
| Type 1 License Totals | 1000 | 1100 | 1200 |
| Type 1 License - Distributor | 800 | 900 | 1000 |
| Type 1 License - Supplier | 200 | 200 | 200 |
| Type 1 License - Other | 150 | 160 | 160 |
Hi, Gingerjeans88
You can try adding filtering to your Page.
At this point, the View of the Other no longer appears on this page.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- CNENFRNLCommunity Champion
- v-zhangtiCommunity Support
Hi, Gingerjeans88
You can try adding filtering to your Page.
At this point, the View of the Other no longer appears on this page.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.