title: Making a Top 5 in Visual Studio
body: <p>I am trying to make a matrix box in Visual Studio 2019 that displays the % total of top 5 (ranked) customers, who have the most items in their count. The problem seems to be that I am trying to get a percent of a ranking that is ever changing and not in a static form. The populated data is coming from the below table where the ranking would come in to play (I have it set as a grouping to do greatest to least in that column)</p>
  <p>I haven't yet figured out if I can do such a thing in Visual Studio as I am new to it. My alternate idea is to make a separate SQL query and merge the two in some way.</p>
  <p>Any assistance or something to point me in a direction is greatly appreciated.</p>
  <p>Example of what I am doing:<br />
  <img src="https://i.stack.imgur.com/HPFny.png" alt="example of what I am doing" /></p>