Skip to Content
0
May 28, 2018 at 05:58 PM

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

86 Views Last edit May 28, 2018 at 05:38 PM 3 rev

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.

Attachments

capturs.jpg (51.0 kB)