Currently Being ModeratedNov 27, 2012 6:19 AM (in response to Snoogle)
Maybe the Filter portion of the Reorganize panel will help you. To open select the table to filter, then select the menu item "Table > Show Reorganize Panel"
Currently Being ModeratedNov 28, 2012 1:49 AM (in response to Snoogle)
I don't understand what you mean by "each category...depends on the other eight categories."
Using your simplified example, with only three categories, let's assume you started with size, colour and material each set to "2".
If you then changed Size to "4", what changes, if any would occur in the other two categories?