This resource is quite helpful, thanks for this. I have been working with Power BI for some time but recently have been required to work on Paginated Reports. I have a question related to this Top N function. I want to show the rest of the Students grouped as Others, the Table will show the names of the Top 10 and then Others. In principle, it will be Grand Total-Top 10 Total. How can this be achieved in Paginated reports? Any help would be much appreciated.
@@saifali4107 Video Published on the Playlist for your requirement, Hope this Helps. Here is below SQL you can refer. WITH GROUP_SORT AS ( SELECT *, case when DENSE_RANK() OVER(ORDER BY Marks DESC)
This resource is quite helpful, thanks for this. I have been working with Power BI for some time but recently have been required to work on Paginated Reports.
I have a question related to this Top N function. I want to show the rest of the Students grouped as Others, the Table will show the names of the Top 10 and then Others.
In principle, it will be Grand Total-Top 10 Total.
How can this be achieved in Paginated reports? Any help would be much appreciated.
Glad you like that and will post my comments or if possible make video on your issue
@@SimpleAnalysis thank you very much.
@@saifali4107 Video Published on the Playlist for your requirement, Hope this Helps. Here is below SQL you can refer.
WITH GROUP_SORT
AS
(
SELECT *,
case when
DENSE_RANK() OVER(ORDER BY Marks DESC)