Need Help on Filtering the data Based On Regions...?

[Anonymous]

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

[sushil353]

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

[MayilVahanan]

Hi

Please refer below link

Slowly Changing Dimensions

[hariprasadqv]

That's SCD. Follow scd handling mechanisms.

[Anonymous]

Hi Plz find the attached Qvw file with Sample Data...