10 Replies Latest reply on Oct 13, 2016 6:15 AM by Shinichiro Murakami

    Ratio calculation - LOD/nested

    Patrick Myles

      Hey all - need a little help with the following - i'd like to have a calculated field to replicate the below example in excel.  (tableau workbook attached with the 'real' value as calculated in excel).  so i need to replicate this calculate within tableau taking into account that i have a data dimension.  Put simple, i need to find

       

      (total sales (person) / total sales (all)) / (total inventory (person) / total inventory (all))

       

      i think it involves an LOD/nested (?) but i am not sure how to go about it.  any help would be appreciated!!

      Thanks!

      Patrick