Wise Owl Answers - How Do I Show a Top 10 Total and a Grand Total in a Report Builder Table?
Автор: WiseOwlTutorials
Загружено: 2021-04-02
Просмотров: 5450
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
