Top 10 totals are wrong

If you have a table with a restricted number of rows (e.g. a top 10) - then there is no way of showing a Total row that includes just that subset of data.

Best Answer

  • Jaketh13



    Accepted Answer

    @simontarry76  It would definitely be more complicated, but you might still be able to pull it off with Rank and Window. Depending on how your data looks, it may be more worthwhile to find another way to get the needed information to your users.


    Is there a particular business question that you want users to be able to answer with this card? Does having the totals for the top 10 results only help them answer that question? If so, and the dynamic filtering is a must, there may be another way to get the users the data they need.


    All that said, it could still definitely be worth it to submit some feedback or add your use case to someone else's feedback in the Dojo Ideas Exchange You can search existing ideas and then vote for it if it matches what you have in mind. If you cannot find it, please create a new Idea which can then be voted on by your fellow Dojo members by clicking the white arrow next to the idea.


  • @simontarry76 That is correct. The "Total Row" and "Subtotal Rows" calculate based on the full DataSet, as the row limit is not a filter, it's just a visual change.


    If you want to be able to look at the totals for just the top ten, ignoring values that fall below that, I would suggest running the DataSet through an ETL and using a Rank and Window tile to do the calculation before it hits your DataSet. This way you can filter based on the rank and your totals will be calculated off of that. Here's the KB article on how they work:

  • Thanks Jake. I should have mentioned that the page we're doing this on has lots of filters. Users expect to be able to filter the page by a few different metrics and the totals update automatically. So rank and window doesn't help us there. 

This discussion has been closed.