4 Replies Latest reply: Jul 8, 2011 4:32 PM by Claude Jakob RSS

    How to create top5 + favorite company + other table

    Claude Jakob

      Hi all,

      I am looking for a dynamic way to create a table that would like this:

       

      CompanySales
      Total Companies600
      Favorite Company20

      Company 1

      100
      Company 290
      Company 380
      Company 470
      Company 560
      other180

       

      I want to be able to always have the top 5 companies in the table and always show my favorite company (even if it is not within the top5). The top5 companies are not always the same depending on filters chosen, so I would need a way to dynamically select for top5 companies. Using the ValueList function appears to be not the right way as it seems static.

       

      Thanks for any lead.

      R/

      Claude