I want to force the user can only select the dimension from 1, 2, 3, and 4. This is the sequence I like to enforce. When user select 2 currency without select 1 product type, nothing happen until product type is selected. Is this possible to configure?
Create a Drill-Down group and use that group as the single dimension in the pivot table. That way a user must select first a Product Type before she/he can select a Currency, etc.