1 Reply Latest reply on Oct 25, 2014 11:12 AM by Shawn Wallwork

    Calculating based on column Month-year and columns shift

    vijaykumar.h

      Hello all,

       

      Please see the attached workbook,i need to display like this in Tableau out of data in the workbook

       

      This is output required out of the Workbook.

       

       

      K1

      K2

      K3

      K4

      K5

      Year,month of

      Registerd_date

      Jan 2010

      Feb 2010

      Mar 2011

      Apr 2011

      Dec 2012

       

       

       

       

       

       

      Jan 2010

      10

       

       

       

       

       

      Feb2010

      Mar2011

      Apr2012

      Dec 2012

       

      Feb 2010

      15

       

       

       

       

       

      Mar2011

      Apr2012

      Dec2012

       

       

      Feb 2011

      10

       

       

       

       

       

      Apr2012

      Dec2012

       

       

       

      Mar 2012

      15

       

       

       

       

       

      Dec2012

       

       

       

       

      Oct 2012

      10

       

       

       

       

       

       

      Thanks!