13 Replies Latest reply on Aug 4, 2017 8:08 AM by Andrew Morgan

    Calculation error

    Andrew Morgan

      Hi Tableau Experts,

       

      I need your help.

       

      I have a table that shows current month,previous month, previous year same month, and % change in values. I have a measure selector and year-month selector depending on that my view will change. Here we are just counting number of customer id. When I select customer count, it shows the correct values..

           

      Now when I change the measure selector to Customer share (countd(cust_id)/ total(count(cust_id)) , shows incorrect result.

       

      Here is the calculation that I am using.

      For each metric selection we are just counting customer id. Third and fourth statements are not giving me the desired result.  I cannot share the data due to security reasons.

       

      Please tell me how to fix this issue Jonathan Drummey Simon Runc Yuri Fal

       

      Appreciate your help.

       

      Thanks in advance.

       

      A.M