Filter Dimension based on Another Dimension

[tm1green]

Hi there,

I have the following dimensions:

Positions dimension

Total Position
--010-123 Engineering
--ENG001 Engineer
--ENG070 Manager
--020-124 Information Technology
--IT001 Analyst
--IT070 Manager

Departments dimension

Total Company
--010 General Office
--010-124 Information Technology
--020 R&D
--020-123 Engineering

I have an attribute created in both Positions and Departments dimensions which contains the department code only like 010-0123 and 020-124. I managed to filter Positions dimension based on Departments dimension as follows,

({FILTER( {TM1SubsetAll( [m_Positions] )}, [m_Positions].[Department] = [h_Departments].[Department Code])})


However, I don't get the "Total Position" in the Positions dimension this way as it does not tied to department code.

How do I filter and get the "Total Position" at the same time?

Thanks in advance.

[declanr]

Union.

[BariAbdul]

A bit more on union:
http://www.tm1forum.com/viewtopic.php?f ... ion#p42289

[mvaspal]

{
{[m_Positions].[Total Position]}
,
{FILTER( {TM1SubsetAll( [m_Positions] )}, [m_Positions].[Department] = [h_Departments].[Department Code])}
}

should also work

[tm1green]

Thanks guys. It works perfectly.