Dimension value to match with other table Dimension

[karthikdaibala]

Hi All,

I have a straight table in which i need to use two dimension values.

For example:

Country	Year	no of Customers	no of sales Persons	TOTAL no of sales persons
Australia	2010	1000	50	60
America	2010	1500	65	125
Australia	2011			60
America	2011	1600	125	125

First three columns are coming from one table

Calendar:

Load Year, Month From Calendar;

LEFT KEEP (Calendar)

Load SalesCountry, CustomerID, SalesPersonID, SalesYear as Year from Sales;

LEFT KEEP (Calendar)

Load Country, Year, salesPersons, Name From SalesPersons;

I cant join these two table as i might miss specific year, instead i need to use them separately and have Country match and year match

My current expression is like : count({<SalesCountry = $:: Country>}SalesPersons), but this is give me only when i select a specific country. I need to this work even though if there is no country selected.

Thanks

Regards

karthik

[Anil_Babu_Samineni]

May be this?

count({<Country = $:: Country>}SalesPersons)

Here, $:: is to use the selection in the default Country filters.instead of $ you can specify the group name to synchronize with it