6 Replies Latest reply on Sep 5, 2018 1:04 AM by Simon Runc

    Changing Tableau's default way of computation

    Mohamed Mosbah

      Hello,

       

      I have sales volume field and I have created 2 calculated fields (share of market and 3MMA).

       

      The problem is, in order to view it correctly, I have to manually adjust the way tableau calculates it by right-click, compute using, cell (instead of across). Now, I am trying to have a dynamic filter to choose between the two views (share of market and 3MMA), but I need to show the filter on the right..and tableau doesn't allow me to do so unless I change the original method of computation without needing to change it manually.

       

      I have attached a tableau file. The first tab has the right calculations but doesn't have the dynamic filter; the second tab has the dynamic filter but wrong calculations.

       

      Please help if possible.

       

      Thanks in advance!!