Wise Owl Answers - How do I calculate percentage of columns in a matrix with multiple groups?
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video explains how to reference total and subtotal cells in a matrix using the ReportItems collection to help calculate percentages of column totals for subgroups.
Chapters
00:00 The Question and Basic Setup
02:34 Showing the Column Total in Each Cell
05:37 Adding a Second Row Group
07:27 Changing the Scope of the Sum Function
09:26 Referring to the Subtotal Cell
11:23 Calculating the Percentage of the Column
12:14 Calculating the Percentage in the Total Column
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!