5 Replies Latest reply on Nov 25, 2017 7:40 AM by Tushar More

    LOD calculations

    sudhir ranajn

      Hi Experts,

       

      How to implement this kind of expression in tableau.

       

       

                                                               INDEX = A/B
      A= SUM(CUSTOMER_COUNT)
            --------------------------------------------------------------------------------------------------

      TOTAL_SUM(CUSTOMER_COUNT) where consider selected STATE, Ignoring all PRODUCTS.

       

      B= TOTAL_SUM(CUSTOMER_COUNT) Consider selected PRODUCTS, Ignore all STATE
             -------------------------------------------------------------------------------------------

      TOTAL_SUM(CUSTOMER_COUNT) Ignore all PRODUCTS, Ignore all STATE

       

       

      Please help me with this.

       

      Thanks In advance!

      Sudhir