2 Replies Latest reply on Jan 8, 2019 6:28 AM by craig Webb

    Divide a Dimension by a Field Within Same Dimension

    craig Webb

      Hello,

       

      I am trying to divide the POS dimension to get a %age of Total Calculation. I am unable to use the Quick Table Calculation provided in Tableau as the Sum of Transactions is not the true total of transactions. The sum of transactions if aggregated would be overstated as each as an individual transaction could contain each POS. For this reason i created a POS called TOTAL. What i would like to do is Divide each POS by the Total POS for Sales and Transactions.

       

      I have came close using the Fixed function but i am not quite there.