https://community.qlik.com/t5/App-Development/qlik-sense/m-p/1744646#M57106 <P>i have two tables master and fact these tables are linked using s.no values from 1 to 6</P><P>I need the sum(amount) for S.no = 4 on selecting S.no= 6</P><P>i used "=If([S.No]=6,Sum({&lt;[S.No]={4},Year={"$(=Max(Year)-1)"},MonthNo={"$(=Max(MonthNo))"}&gt;}Amount),0)"&nbsp;</P><P>This didn't work</P><P>need help please</P> Thu, 17 Sep 2020 09:00:47 GMT Ravi1 2020-09-17T09:00:47Z https://community.qlik.com/t5/App-Development/qlik-sense/m-p/1744646#M57106 <P>i have two tables master and fact these tables are linked using s.no values from 1 to 6</P><P>I need the sum(amount) for S.no = 4 on selecting S.no= 6</P><P>i used "=If([S.No]=6,Sum({&lt;[S.No]={4},Year={"$(=Max(Year)-1)"},MonthNo={"$(=Max(MonthNo))"}&gt;}Amount),0)"&nbsp;</P><P>This didn't work</P><P>need help please</P> Thu, 17 Sep 2020 09:00:47 GMT https://community.qlik.com/t5/App-Development/qlik-sense/m-p/1744646#M57106 Ravi1 2020-09-17T09:00:47Z