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


      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.