title: Is there a way in Tableau server to limit the rows displayed but then download the complete data into a crosstab?
body: <p>I have a large text table (about 200k records) that's generated from a custom SQL query.  I've added filters so users can limit the output, but the text table is still quite large, so rendering of the table is pretty slow.  I know that I can limit the rows displayed using a calculated field like Index().  However, what if I want to limit the rows displayed to the user, but still enable them to pull the full dataset?  In other words, lets say they filter by ID #123 and the text table has 5k records with ID #123.  I want to display at most 100 of these records in the dashboard and if they need the complete raw data, they can pull the 5k into a crosstab.  Currently, if I apply an Index to limit the rows displayed in the dashboard to 1k, they'll only be able to download 1k records to the dashboard.  </p>
  
  <p>Ultimately, the purpose is to make the raw data available, but make the experience using the dashboard a lot faster.  </p>