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

    Calculated Field with long data format

    steve.riedo

      Hey there,

       

      I have the following data (in long format):

       

      TableauCommunity1.JPG

       

      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:

      TableauCommunity2.JPG

       

      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!