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 www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Download the required file here www.wiseowl.co.uk/report-buil...
Learn how to use aggregate functions like Sum, Avg, Count and CountRows in recursive groups in Reporting Services.
Chapters
00:00 The Question and Basic Setup
01:30 Creating a Recursive Group
02:38 Formatting the Hierarchy Levels
05:53 Summing a Field in a Recursive Group
07:49 Including the Current Level Value
09:15 Excluding the Current Level Value
10:30 Excluding Rows with No Subordinates
13:13 Creating a Sum If Calculation
15:21 Referring to the Level in a Sum If Calculation
16:00 Averaging a Field in a Recursive Group
17:16 Including the Current Row in the Average
19:00 Creating an Average If Calculation
20:07 Calculating the Average of Subordinates
Visit 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!
5 авг 2024