4 Replies Latest reply on Aug 31, 2017 3:57 PM by Okechukwu Ossai

    Dynamic Calculated Field

    Allan Bonilla

      Hi,

       

      I am new in Tableau. I have the following data

       

      Market
      ProductMonthInventory (Units)Monthly Forecast (Units)*Month On Hand(MOH)
      AAAX1JAN10002005
      BBBX2JAN20003006.7
      CCCX3JAN30004007.5

       

      *Calculated Field

       

      I would like to know  how I can create a Calculated Field associated to the filters. For example, if I make and Scatter Plot and I just want to know what is the MOH for JANUARY selecting in the filter, Tableau will sum the MOH field and not just replicate the calculation of Sum (inventory of JAN)/ sum (Forecast of JAN). This should be like a pivot table Excel calculation.

       

      Regards.