An Analysis will produce a logical SQL and in most of the cases a single physical SQL. I am thinking whether or not there's a way that I myself can write a physical SQL that will produce two separate result sets when there's only a single WHERE clause.
Would creating two separate Analyses and displaying them on a single dashboard page be not an option in your environment? If the table view is sorted as per the Pareto and paginate the table view so that it shows 15 rows at a time? The Analysis displaying the Pareto will be restricted to the top 15 but the Analysis containing the table view won't be.
The Pareto will always calculate the % values based on the data fetched.
I think whatever description you have given is an intended functionality.