Forum Discussion
Solved
Top N based on Matrix Total
I created a matrix that counts the number of surgeries in a year done by a provider. How am I able to filter the top 10. The data is coming 3 seperate tables, Table 1 = Surgery Type, Table 2 = Surgery Date, Table 3 = Surgery Location.
I think I figured it out. I need to create a new measure of the surgery performed.
2 Replies
Hi mattmc_513 ,
Please provide sample data and your expeced result.
Which table is the number of surgeries from, the yeaar, the provider? How are the tables related to one another? Show the relationshi view.
I think I figured it out. I need to create a new measure of the surgery performed.
