Filter off of data item?

[starterdev]

Hi all,

I am trying to create a report where one specific line (a created calculated member) is filtered to only apply to a specific location, but the others can contain all locations.

For example- Sales Managers is the name of a department with multiple locations- Central, Country 1, Country 2 etc.  But for the purposes of this report, on this particular line, I only need to see the sales manager data that corresponds to Central.  Country 1 and Country 2 are so small that they are just rolled up and not split out by department.

Both the departments as well as the divisions are seperate data items.  Is it possible to create a filter that will only return the sales manager data for just the specific division of Central?

[MFGF]

Hi,

Without seeing your expressions it's hard to be sure, but it sounds very much to me like all you need is a tuple() function to provide the intersection between your calculated member, the Central location and your measure.

Cheers!

MF.

[starterdev]

That was perfect!!!!!!!! 8) 8)!

Major kudos to you MFGF!!!!!