Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having a filter- employee and a straight table with 2 dimensions only - Region and country. no measures.
every employee belongs to a specific region and a country in that region. I need to display a table where a region (1st column) of the selected employee is displayed and a country (2nd column) shows all the countries mapped to the region (ignoring employee selection). so in short, employee selection should impact only Region dimension and not the country.
Hope I am clear with the requirement.
Regards,
OK
Hi
First Create a variable like
vRegion
=Concat(chr(39)&Region&chr(39),chr(44))
This will get the region based on employee selection and store it in a variable "vRegion"
Next create an Alternate state which u will find in master item like 'NoEmp'
Next Create a table with Region and Country
For region use this expression
=IF(Match(Region,$(vRegion)),Region)
Country - take as it is
In Appearance section u will find alternate state their set it 'NoEmp'
Now if u select any employee the region will show for that particular employee and all the countries
Note : if u dont want to show the countries where regions are not there just uncheck show null values from the region dimension
I hope this resolve your issue
Thanks and Regards
Kashyap.R
I believe set analysis expression can ignore the selection. find one example here: https://www.youtube.com/watch?v=eG4E5SwjFzE
Thanks Vicky, the example shows set analysis used in a measure to ignore selection but I need it in dimension (no aggregation). I can't use set analysis in dimension.
Hi
First Create a variable like
vRegion
=Concat(chr(39)&Region&chr(39),chr(44))
This will get the region based on employee selection and store it in a variable "vRegion"
Next create an Alternate state which u will find in master item like 'NoEmp'
Next Create a table with Region and Country
For region use this expression
=IF(Match(Region,$(vRegion)),Region)
Country - take as it is
In Appearance section u will find alternate state their set it 'NoEmp'
Now if u select any employee the region will show for that particular employee and all the countries
Note : if u dont want to show the countries where regions are not there just uncheck show null values from the region dimension
I hope this resolve your issue
Thanks and Regards
Kashyap.R
Thanks a lot @Kashyap_R , it's working as expected 🙂