Pivot tables and connected fields?

[Lista]

Good day all,

this is an issue I've been trying to solve for quite some time now.

I have a sheet that contains three headings: Brand, Model of a car and their prices. My ultimate goal is to achieve the 'dependent list' form, where when I choose one Brand, only Models of that specific brand will be shown in another list/field. I hope this is clear, it further clarification is required - that's not a problem either.

I think I have two options.

1. Pivot tables: Here I could use features like automatic totals, sums and so on, but I encounter problem with connecting two fields (Brand and Manufacturer). Picture of this is also attached. Ideally, since BMW is selected, only it's models would be visible in the second field.

Is this possible to achieve?

2. Dependent lists. But then I loose the totals, sums features that come automatically with Pivot tables, and that requires more coding.

I'm actually asking from you to advice me which way to go, give me useful links or anything that could be of any help.

Thank you very much.

[no dice]

1. Your pivot table will work if you move 'model' from the Page field to the Row field. You could then leave 'who ordered' in the Row field or move to the Column field or swap them both depending which look you like.

2. Use the AutoFilter Option to sort your tabular list by 'Brand' and the only the associated Models will appear

[Lista]

That simple - thank you very much!

However, I'm still interested in knowing wheter connecting two page fields is possible or not?

[no dice]

I'm not certain I understand the question of connecting the two page fields.

If you are asking whether or not one page field can adjust dynamically based on the selection of another page field... I don't know. I don't think so, but the code warriors around this site continually amaze me with functionality.