cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Grand Totals not displaying with Matrix (with screenshot)

I've got this Matrix where its doing totals for rows, but not columns.  Also there is no grand total.

 

In the area in red, is the current row totals....I'm looking to get totals in the blue area.

 

I've tried everything I can but can't get it to work for some reason.

 

totals.png

 

6 REPLIES 6
Highlighted
Anonymous
Not applicable

@unclejemima,

You can toggle Column Subtotals to On by going to the Format pane of your matrix

 

 Subtotal.PNG

Highlighted

Already on.

 

And I checked to make sure its not hiding down at the bottom with a scroll bar.

 

Nothing there.

 

Any other idea's?

Highlighted
Community Champion
Community Champion

@unclejemima

 

Looking the Matrix you are Values Show on Rows to ON . Right?

 

So every Column Insert in Values are Independent.

 

Regards

Victor

 

 

 




Lima - Peru
Highlighted


@Vvelarde wrote:
 

Looking the Matrix you are Values Show on Rows to ON . Right?

 


Yes.  Is it not possible to show totals then with this turned on?

Highlighted
Helper II
Helper II

No follow up to this?

Highlighted
Helper II
Helper II

This would be valuable, is there any vote possibility for this?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors