1 2 Previous Next 22 Replies Latest reply on May 22, 2015 9:02 AM by Ari Bibas

    Difficult (I guess..) : show total as a mere calculation of above rows

    Ari Bibas

      Hello,

       

      I am struggling against something that looks obviously trivial in theory but that appars to be a nightmare for me.

       

      I have created some complicated calculation fields from multiple sources. I want to run my calculations on a subdimension, but to show the total at the dimension level.

       

      Example : Category A, B, C, Subcategories A1, A2, A3, B1, B2...

      I want to run my predictive analysis for A1, A2, and A3. Let's say that the output is respectively 10, 15 and 20. I want to show that at A level, we have a total result of 10+15+20 = 45.

       

      The problem is that using the Analysis tool to insert the Total of Columns will have Tableau to run a new calc at A level, giving me another output (my formulas are not linear...).

       

      I am afraid that I cannot use LOD calculations because I am using multiple sources of data( Am I wrong?).

       

      So is there a way to do the most simple thing of the world, showing a mere addition of figures already calculated??

       

      Thanks in advance!

       

      Ari

        1 2 Previous Next