Change view based on drop-down?

Change view based on drop-down?

My organization is trying to decide between QuickBase and Zoho Creator and a question will help clarify if Creator can meet our needs:

Is it possible to have an HTML page which has on the top half a set of dropdowns, through which on the bottom half a different view is generated?

An example would be:

1) On the top I have a drop-down list of offices that collect donations for a non-profile

2) On the bottom half a different view table is generated based on the drop down selected in 1.

Additionally.. is the it possible to do the same thing with a pivot table?  Such that the selection of the drop-down will define what data is shown in the pivot table report shown on the bottom?

Thanks!