Depending on where the data for a table originated from, additional options for interacting with the data may exist.
SQL
Edit Parameters
- Link the query parameters to Excel cells or slicers.
Edit Connection Range
- Link the Connection String to a cell, allowing driving the server or database from other parameters in the workbook.
Tabular Analysis Services
Breakout (available from measure columns)
- Create a ranked list of the top or bottom values making up the number selected.