I want to create a condition (in enable condition from the dimension tab in a pivot table). I have the following table. I have a list box for the MenuSelection field. Depending on what is selected the dimension in the pivot table will (or won't be enabled):
Revenue Line of Business
So if the user selects "Revenue" (in the List Box) then in the pivot table Branch, Department and Line of Business will be enabled, but if Expense is selected (in the List Box) then only the Branch or Department dimensions will enabled but the Line of Business dimension field will not be enable because it is not associated with Expenses
Actually that table is just a small representation of many more records. For example I want to set up a dimension for Branch and maybe 7 out of 10 selections in the ListBox are related to Branch. If one of those is selected then Branch will be enabled. Some kind of aggr function or something?