2 Replies Latest reply on Mar 27, 2018 8:00 AM by Jim Dehner

    Simple calculation in Excel can't be done in Tableau?

    Andriy Pushkar

      Hi dear Tableau community.

       

      I have a very simple excel file attached - where I need to calculate column2 based on the formula described in excel.

      But I just can't figure out how can I do the same in Tableau?

       

      I was able to figure out the first part - ($C2/$C$12). But I do not know how can I get second part working - which is *B$12.

      Problem is that I have this *B$12 value only in one row (grand total value) - so can't multiple it for each in Tableau.

       

      What I have in Tableau is this:

      column2               column3

        

      056
      0120
      047
      06
      0114
      045
      075
      020
      0115
      06
      130604

       

      Any help would be much appreciated.

      Thanks in advance.