Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Additional Matrix Summary Column Options (% of Sub Total/Grand Total)

Add a feature under the Matrix Visual's Column Grand Total that may be toggled to include additional Grand Total summary options aside from just the SUM it performs naturally. This way beyond just have a grand total column you can also include a % of the grand/sub total column. This proves especially useful when using a calendar table to populate months across a matrix as each column isn't it's own measure so it's not simple to just add an extra measure to the end of the matrix.


Currently if a matrix is created each row can only be summarized in one manner. If you wanted to also include each row's % of the Grand Total (or Sub Total), a new measure would need to be written and included in an additional matrix and hidden behind which can cause potential formatting issues down the road. Another option would be to right many-many dynamic measures to

Status: New
Comments
fbcideas_migusr
New Member
Status changed to: New