2 Replies Latest reply on Jan 21, 2019 6:31 PM by Deepak Rai

    Calculated Field value changes in visualization when Dimension is Added


      Hello ,


      I have a very confusing problem with my data analysis in tableau . I have created various calculated fields. When displayed separately ,without dimentions added, values are correct e.g % Female smokers is 0.55



      When I add dimension to the column it changes the calculation to 5.


      I am having the same problem throughout the workbook ( sheet 1- Distribution by gender). If you see calculations fields seperately for males , females and transgender you can see actual correct values but when I add dimensions the values chage automatically regaldless of my calculated field results. It'll be great if someone could help me understand what's going on.

      My workbook is attached.