Hello,
I have a large data set that is similar to the following.[TABLE="width: 500"]
<tbody>[TR]
[TD]Prod[/TD]
[TD]$ Sales[/TD]
[TD]Unit Sales[/TD]
[TD]Volume[/TD]
[TD]% Disc[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]$100[/TD]
[TD]50[/TD]
[TD]300[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]$150[/TD]
[TD]25[/TD]
[TD]150[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]$75[/TD]
[TD]100[/TD]
[TD]200[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]$200[/TD]
[TD]75[/TD]
[TD]50[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]
What I ultimately want is a dynamic table (separate from the large data set and with all the same headings) where the user can select (with a button?) which metric they want to rank on and it would show the top 5 entries for that metric. Hopefully that makes sense. Thank you!
I have a large data set that is similar to the following.[TABLE="width: 500"]
<tbody>[TR]
[TD]Prod[/TD]
[TD]$ Sales[/TD]
[TD]Unit Sales[/TD]
[TD]Volume[/TD]
[TD]% Disc[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]$100[/TD]
[TD]50[/TD]
[TD]300[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]$150[/TD]
[TD]25[/TD]
[TD]150[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]$75[/TD]
[TD]100[/TD]
[TD]200[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]$200[/TD]
[TD]75[/TD]
[TD]50[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]
What I ultimately want is a dynamic table (separate from the large data set and with all the same headings) where the user can select (with a button?) which metric they want to rank on and it would show the top 5 entries for that metric. Hopefully that makes sense. Thank you!