I have created a SSRS table that i have created with SharePoint data source. I have more than 30 column with yes and no value in that SharePoint list. I am trying to count the yes values, and then display top 10 columns on this SSRS report. I am able to pull the true count but however not able to only show top ten. Should i create a new table to pull information from this table on the same report?
How would you do it if L1, L2, L3, etc... were not from one field but are all different fields?