If statement to change dimension with selection

[#1]

I have 2 variables Region_Old and Region_New (from 2 different datasets - Old and New)- both have similar fields but for different row fields. My whole sheet uses Region_New but for one GAUGE chart i need to use Region_Old.

So when the user selects "Asia" in Region_New listbox i want it to lookup "Asia" in Region_Old and show numbers for that instead of the Asia per Region_New.

Please help?

[#2]

How similar are they?

If they're exactly the same, you might be able to get away with naming both variables 'Region', and using it as a link between the two tables. Since the row fields are different, they should have different names.

If they aren't exactly the same, you would probably have to do something fancy with AGGR() to get the two tables linking up correctly.

[#3]

No, naming them the same and linking won't work. Already have a key and usind this one won't link the tables correctly anyway.

Think of that chart as stemming only from that "Old" data sheet. This region field shouldn't impact all other charts and vice versa.

P.S. Aggr won't work. Alternate states is closer to what i need but it'd be too complex/confusing for a User who won't know crap about it.

[sujeetsingh]

Hi Asakshi,

First of all you can handle this in Script too.

Now for UI level plz provide a sample !!