1 Reply Latest reply on Jan 5, 2015 9:48 AM by Patrick Van Der Hyde

    Help in writing calculated field and formula

    Piyush Athawale

      I am new to Tableau and I need help writing a formula which looks something like this:

       

      (% Company A Sales of Product A in Yr. 2 * %  of Product A in Overall Products A-Z in Yr. 2) - (% Company A Sales of Product A in Yr. 1 * %  of Product A in Overall Products A-Z in Yr. 1)

       

      So for e.g. Company A has 23% of sales of Product A with respect to its competitors and Product A is 25% of the overall Product Market in Yr. 2 and for Yr. 1 it is 30% and 35%