Has anyone successfully limited the saved search r...
# suiteanalytics
l
Has anyone successfully limited the saved search results to Top x results? Like top 10 with the highest total amount, etc. I tried the Run Unrestricted and Max Results. Yes, it does show the top 10 but the total shown is the grand total of everything that meets the criteria of the saved search not the total of the top 10. Rank and Dense Rank are not working on Criteria subtab.
d
Add a Formula (Numeric) criteria Formula ROWNUM less than 10
l
I have summary functions. So that won't work, right?