How can I reflect the second datamodel with respective selection of first datamodel

[hemanthaanichet]

Hi All

I have scenario like i have two data models. Both the data models are same but the table name & column names are different. if i select the first data model year & month for that year & month my second data model has to reflect and has to display the values as per the selection

Note: Both data model could not be  linked.

for example:

DataModel 1

Year , Month

Sum ({<Year={$(=max(Year))}, Month=>}Sales)

Datamodel 2

Year1 , Month1

Sum ({<Year1={$(=max(Year1))}, Month1=>}Sales1)

Regards

Hemanth

[tresesco]

Way1: Use field event trigger to select other model field on one's selection

Way2: Refer other model field in the expression like:  Sum ({<Year1={$(=max(Year))}, Month1=>}Sales1)

Now, here you have to decide on which model field Year1/Year would be referred when.

[hemanthaanichet]

thanks Tresesco ..

way 2 is not working properly it refelects but the values are not matching....

can pls say the way 1 with a example plsss...

[tresesco]

Please share a sample to work upon.

[hemanthaanichet]

sample data but give any expression ...... so it easy to start from the base

[tresesco]

[hemanthaanichet]

yeah this working but best way is event trigger if u dnt mine could pls do a sample for me pls.....

[tresesco · Accepted solution]

PFA