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
Смотрите видео Wise Owl Answers - How Do I Show a Top 10 Total and a Grand Total in a Report Builder Table? онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь WiseOwlTutorials 02 Апрель 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4,372 раз и оно понравилось 44 людям.