Wise Owl Answers - How Do I Show a Top 10 Total and a Grand Total in a Report Builder Table?
Check out our other answers here • Wise Owl Answers
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video shows several ways to create a total for the top 10 records in a Report Builder table. You'll learn how to write a SELECT TOP 10 statement in SQL, how to apply a Top N table filter in Report Builder, how to alter the scope of a Sum function, how to use the ROW_NUMBER, RANK and DENSE_RANK functions in SQL and how to combine the Sum and IIf functions in Report Builder to simulate a SumIf function.
Chapters
00:00 The Question
00:21 Adding a Table Total
02:29 Creating a Top 10 Query
05:59 Adding a Top 10 Table Filter
08:20 Changing the Scope of the Sum Function
10:17 Calculating a Rank in SQL
14:25 Creating a Sum If Expression in Report Builder
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Watch video Wise Owl Answers - How Do I Show a Top 10 Total and a Grand Total in a Report Builder Table? online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 02 April 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,372 once and liked it 44 people.