Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!
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)
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)
Hi ng21july,
Hope attcahed file will help you.