5 Replies Latest reply: Apr 23, 2017 10:32 AM by Muñoz Héctor RSS

    Using estimated value from another table

    Ignas Dukynas

      Hello everyone

       

      I need very much help with this estimation.

       

      I have Table 1 and Table 2.

      • Year- dimension
      • Two measures: Country 1 and Country 2

      Capture.JPG

      Table 2 uses Total values from Table 1 estimating values.

       

      I cannot find how I can get Total value (From Table 1) calculating Table 2 without typing full formula that is used in Table 1. Is it possible somehow to refer to the Total value? Maybe there is any formula to get the Total value?

       

      I cannot type in Table 2 full formula from Table 1, because I do not have enough space in the script as both Tables are much more complicated than the example.