9 Replies Latest reply on Aug 4, 2016 11:09 AM by Patrick T

    Level of detail calculation help

    Patrick T

      Hi,

       

      I made a sample data set with three variables: date, Animal (type), number bought (value).

       

      tableau example.PNG

       

      I am trying add percent of total bought to the tooltip (ie. chickens account of 37% of all animals bought for <date>). I would like the percentages to remain constant, if I filter an animal type out.

       

      I have been trying to set up a level of detail calculation for the denominator, but I'm not having any luck

       

      I tried: {FIXED [Date] : SUM([Number Bought)} but it returns the number bought for each animal type, exactly like SUM(Number Bought) gives

       

      I tried: {FIXED : SUM([Number Bought])} but this gave me the total number of animals bought ever, without taking date into consideration.

       

      I have attached a copy of the workbook. Maybe someone can lend a hand, and give an explanation of what I'm doing wrong? Thanks.