Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Need Help Form you guys regarding the Region wise Agents filter.
Requirement is I have 100 Agents in Region INDIA , After few years 40 Agents Moved to US , Now I want to show All the 100 Agents Names including those who Moved from INDIA also when i Select INDIA , But With Null Values , if I select US it has to show 40 agents Complete data...
Attaching the Sample Qvw: Plz look in to this Observe Agent 1 & 2 , these 2 agents are moved from HYD to H99 ,now if I select HYD it has to show 10 Agents including 1 & 2 also. and it has to display Null values for agents 1 & 2.
when i select H99 it has to disply 1 & 2 Agents with their New Sales..
Help on the Above issue is highly appreciable...
thanks in Advance...
Regards
Anusha.K
Hi,
It is better if you share a sample dataset.
Still you can try below solution.
=if(getfieldselection(Region) = 'India',only({<Region=>}AgentsNamefield),AgentsNamefield)
HTH
Sushil
Hi
Please refer below link
That's SCD. Follow scd handling mechanisms.
Hi Plz find the attached Qvw file with Sample Data...