In report display NULL in dimension against some specific condition

[#1]

Hi,
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 :

1. Person

2. Fact

3. Address

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.

e.g

Person	State	Flag	Sales1	Sales2
A	abc	N	100000	565222
NULL	NULL	Y	200000	233556
C	xyz	N	300000	225655
NULL	NULL	Y	100000	122555
NULL	NULL	Y	500000	122445

Kindly suggest how to implement this.

Thanks in advance !!

[#2 · Accepted solution]

Instead of selecting the person as the dimension, try to make a calculated dimension, where you put some code like this:

=if(Flag = 'Y', null(), Person)

[jvishnuram]

Hi ng21july,

Hope attcahed file will help you.