2 Replies Latest reply on Aug 2, 2012 5:16 AM by ernesto debeaumarchais

    Year over Year text report

    ernesto debeaumarchais

      I need to put together a text report showing two years of information with a YoY difference.  See the attached pic for a simple mockup.  Is it possible to do without having a whole blank 2001 year?

        • 1. Re: Year over Year text report
          Tracy Rodgers

          Hi Ernesto,

           

          When finding YoY Difference using a table calculation, the best way around not having a blank column for 2011 is to create two separate sheets and place them on a dashboard together. One sheet will have the values for both years, and the other sheet will have only the difference.

           

          Hope this helps!

           

          -Tracy

          • 2. Re: Year over Year text report
            ernesto debeaumarchais

            When you say one sheet will have the values and one will only have the difference - is there a way to just import the data values and calculate the difference in tableau?  Or do you mean I need to calculate the difference outside of tableau and import those numbers?

            I assume the second?  I can't see a way to calculate the difference in tableau outside of using a table calculation with both years, but then you get a blank year.