How to get the annual aggregated value in the Month column?

[elachimy]

I invite you to find an example in the attached capture.
in the right table I want to put the following rule of calculation: (Value Month / Value 2015), ie :

- France / January  : (0.39 / 2708.25)
- France / February : (0.41 / 2708.25)
- France / March    : (1.63 / 2708.25)

- Usa / January  : (28 / 150335)
- Usa / February : (14 / 150335)
- USA / March    : (9 / 150335)

but it does not work. when i set the calculation rule it shows me empty columns for each month. I can not recover the value of 2015 in the monthly straight table

Thanks in advance.

[elachimy]

problem solved. it works very well.

Thank you very much.

[elachimy]

problem solved. it works very well.

Thank you very much.

[amitrathi239]

my understanding is your base data look like.

And you want to achieve like this.

If yes then follow below steps.

Create variables V Month=Month([Month/Year])

V Year=Year([Month/Year])

2015=[Values] Where ([V Year]=Min([V Year]) In Report) In ([Country])

2016==[Values] Where ([V Year]=Max([V Year]) In Report)

Final variable=([Values] Where ([V Year]=Max([V Year]) In Report) /[Values] Where ([V Year]=Min([V Year]) In Report) In ([Country]))*100

[elachimy]

I invite you tofind an example in this capture :

in the right table I want to put the following rule of calculation :(Value Month /Value2015), ie :

- France / January : (0.39/2708.25)

- France / February : (0.41/2708.25)

- France / March : (1.63/2708.25)

- Usa / January : (28/150335)

- Usa / February : (14/150335)

- Usa / March : (9/150335)

but it does notwork. when i set the calculation rule it shows me empty columns for each month.I can not recover the value of 2015 in the monthly straight table

Thanks in advance.