Hi
I would like to create a simple dynamic table in a spreadsheet somewhat similar to pivot table functionality.

Is it possible to create a table where the data in the table changes dynamically based on a filter for the table? This would be similar to having a drop down filter for a pivot table.

Paul