1 Reply Latest reply on Feb 12, 2015 3:45 PM by Patrick A Van Der Hyde

    SUMIF type calculation based on groups of years

    Aaron Burdick

      Hi there,

       

      So I have a timeseries set of data and I need to run calculations to get aggregated % values based on groups of years.

       

      For example, 2011-2013 would be group 1, 2014-2016 would be group 2, 2017-2022 would be group 3 (note they are not all the same size). I want to sum X over 2011-2013 and divide by Y over 2011-2013, in order to get % Z that applies to the aggregate group 1 period (2011-2013).

       

      It's an easy SUMIF in Excel. How can I do this in Tableau?

       

      Thanks!

      Aaron