Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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