Filtering available Dimension values based on an other dimension selection -
11-02-2004
, 08:34 AM
This solution displays information from several companies. Frontend is
Excel. Company is one of the dimensions. When selecting Company I want some
other dimensions to be limited to dimension values defined for this company:
Territory 1 is relevant for Company A, B and C
Territory 2 is relevant for Company A and B
Territory 3 is relevant for Company A
When Company = All then the dimension Territory should display 1, 2 and 3.
When Company = B then the dimension Territory should display 1 and 2.
Is this possible?
Regards
Einar N. |