4 Replies Latest reply on Nov 7, 2016 10:27 AM by Sherzodbek Ibragimov

    Ratio between first and last

    Emilie Anderson

      I'm having trouble doing a simple calculation. I'm new to Tableau so there may be an easy solution I can't figure out.

       

      I have a column "Business Volume" and a column "Fiscal Year." Business Volume appears on the graph as Business Volume, and not anything like SUM(Business Volume), which is how I want it. However, this makes it impossible to do a quick calculation, obviously.

       

      I'm trying to do a calculation of the ratio between the business volume of the first fiscal year (2002) vs the business volume of the last fiscal year (2015). I will be adding more fiscal years (1999-2001 and 2016) and their corresponding business volumes as I continue the project, so I want the calculation to be dynamic.

       

      Is this sort of thing possible and if so, how can I do it?