Hi I am looking for a way to limit both the displayed rows AND the displayed columns.
Use case is that I am looking to display the top 5 articles with the highest volatility day to day.
- I am calculating rate of change day to day across 2 rows
- sorting based on rate of change results
- limit displayed rows to show first 5 rows
- limit displayed column to show most recent date
If anyone have a solution to displaying the columns or a different way of solving this problem, your advise would be a godsend