cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
uthall Regular Visitor
Regular Visitor

Grand Total Only

Hello,

 

I would like a matrix to show the grand total only, and not the subtotals..

 

There doesnt seem to be any option for this very basic requirement.

 

Am i missing something?

1 ACCEPTED SOLUTION

Accepted Solutions
tringuyenminh92 New Contributor
New Contributor

Re: Grand Total Only

Yeah, Agree with @KHorseman, @uthall you should let matrix show details and turn off total row,column. and then show Grand total in Card next to matrix.

9 REPLIES 9
tringuyenminh92 New Contributor
New Contributor

Re: Grand Total Only

Could you post the sample data and your expectation picture? so I could quickly help you to solve it.

uthall Regular Visitor
Regular Visitor

Re: Grand Total Only

Matrix.JPG

 

Hi, and thanks

 

See above screenshot.....

 

 

 

tjd Established Member
Established Member

Re: Grand Total Only

I have been working on the same type of problem and it seems to me that you're only going to get the solution you are looking for (right now) by either using only one category.  Seems to me that if you use more than one category in a matrix, you can only get each category's row and sub-row totals which is what you don't want.  I had to switch my visual to a table (from a matrix) in order to get the view you show; but then you lose the nice category formating of the matrix (:.

KHorseman Super Contributor
Super Contributor

Re: Grand Total Only

You can't selectively turn off subtotals in the matrix visual. You either get subtotals for everything, or no totals at all. Those are your only options. For some reason they left this basic feature out. The best workaround I've found is to write a measure that produces some of the items you would use for the non-subtotaling columns, and use that in the values.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
tringuyenminh92 New Contributor
New Contributor

Re: Grand Total Only

Yeah, Agree with @KHorseman, @uthall you should let matrix show details and turn off total row,column. and then show Grand total in Card next to matrix.

uthall Regular Visitor
Regular Visitor

Re: Grand Total Only

Ok, not a bad workaround, but hard to position the card if the number of rows in the matrix is variable depending on filters.....

kmalecka Frequent Visitor
Frequent Visitor

Re: Grand Total Only

Hi Smiley Happy how to show details as I cannot see this option my goal is to have grand total but not row totals

kmalecka Frequent Visitor
Frequent Visitor

Re: Grand Total Only

how to show detail I cannot fidn this optionSmiley Sad I also woudl liek to se teh grand total of a row but not see sub totals

kiltannen Frequent Visitor
Frequent Visitor

Re: Grand Total Only

I realise I am a bit late to the party on this discussion, but I recently needed to do something very like this, and found a different way to accomplish it.  

 

My need was also to have multiple columns display the total - with several different measures etc. this meant I really needed to find a way for the matrix to provide this.

 

My approach was to make a 2nd copy of the matrix, then turn subtotals on, but to narrow the height of the matrix until ONLY the header and the Grand Totals row were displaying. This then meant I could place things where I needed to, display the grand totals, AND NOT the subtotals. 

 

I did place the first matrix on top (in front) of the header row on my second matrix - which allowed a bit of ugly text leakage.  This I fixed by placing a white box strategically in front of my 2nd matrix to hide the header row - but behind the 1st matrix.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 42 members 925 guests
Please welcome our newest community members: