This content has been marked as final. Show 2 replies
I have a scenario where I need to display Person,City,State, Sales1, Sales2 in a report in QV.
At the Data Model Level, have 3 tables :
where Address and Person are joined to Fact Table based on AddressKey and PersonKey respectively.
There is a Flag field in the Fact table with Y and N value.
The report should be displayed such that, for all records with Flag=Y in Fact table,
the identity (i.e. Person,City,State) should not be visible(NULL should be displayed) in report while Sales1, Sales2 should be displayed in report.
NOTE : Blank or some other text can also be placed in place of NULL.
Kindly suggest how to implement this.
Thanks in advance !!