Hello All,
I have a dimension table that has client name and intouch id column. Also I have other fact table that contains clients other information and am filtering them through Report Level Filter by client name, these both are shown in report using table visual. They both have relationship by intouch id column. Now in dimension table there are many clients that have blank intouch id.
So now if i select a client name that has blank intouch id in my fact table by report filter , then all records that have same blank intouch id will be displayed in my dimension table but i want the client detail in dimension table to be displayed of only that particular client not others whose intouch is also blank.
How can i achieve this by using filter pane or other method.
Sorry I cant share the data.
Thanks in advance,
Chahat
