Can't display grand total without showing subtotals in Matrix?

[paguy215]

I want to display the grand total of columns but not the subtotals:   In the below image the first three 'columns' are actually rows that I removed the stepped layout for...after the date are the actual columns, which are counts by sales type.   I want to show the grand total of each of those sales types at the bottom, but not the total under each row.  I've tried playing with various things but can't seem to get that to work

Here is the latest set up I have ... I've tried it all 3 levels of the rows ...customer ID, ticket number, and date and I can't get the visual to work.   

[Anonymous]

Hi @paguy215 ,

Based on the information you have provided, can you provide some example data such as detailed data (without sensitive information) and your desired output. This would allow us to better reproduce and solve the problem you are experiencing.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.