2 Replies Latest reply on Apr 20, 2018 7:44 AM by Zhouyi Zhang

    Calculated Field with long data format


      Hey there,


      I have the following data (in long format):




      I would like to know, for each year, and for each Region, the value HIV163 / HIV46 - i.e. the percentage of the second to the first value.


      The result should be something like this:



      This is only a small snapshot of a very large dataset, so manually creating the required fields would not work.


      Thank you in advance, your help is greatly appreciated!