Story Calculations between 2 tables in SAP Analytics Cloud

[Sumalini]

Hi All,

I have 2 tables as shown below. Based on User Input, It will look back to 3 years data and will display in the tables.

		2020	2021	2022	2024
Country
USA		100	200	300	400

Here, i have to calculate the Rate in the below table, for which i have to use the total amount for the corresponding year from Table 1 as a denominator as shown below dynamically.

		2020		2021		2022		2024
		Value	Rate	Value	Rate	Value	Rate	Value	Rate
Country	Code
USA	A	50	(50/100)*100	20	(20/200)*100	40		60
	B	40	(40/100) *100	30		50		70

Could someone please help me on how to achieve this?

[N1kh1l]

@Sumalini , Based on type of your model you can explore usage of RESULTLOOKUP, ACCOUNTLOOKUP or MEASURELOOKUP.

Nikhil