4 Replies Latest reply: Jan 2, 2014 5:52 PM by Paul Yeo RSS

    How to make most recent year display on the last column ?

      Hi All

       

      May i know How to display only the most recent year revenue amount ? meaning for PRECICON dispaly 2013 amount only.

       

      I have this table from raw data file
      COMPETITORyear200820092010201120122013
      PRECICON 27,506,17018,658,31222,227,81026,113,93823,799,00018,935,000
      PHOENIX 49,521,51838,434,95943,685,133---
      WAGO 7,076,1526,303,6718,992,308---
      INTERMECH 16,568,61012,034,97716,690,99517,552,873--
      SMC 70,481,46655,589,61764,455,803102,317,790--
      ROCKWELL 46,815,627-----
      SIEMENS 679,874,000542,037,000----
      MITSUBISHI 242,890,943219,475,152----
      EUTECH 20,034,79317,504,690----
      DAIFUKU -14,532,517----
      MOTION CONTROL GROUP 652,946961,870----
      OMRON 23,090,56518,486,801----
      I like to transform the above table to below :-
      COMPETITORyearCurrent Yr3Current Yr2Current Yr1
      PRECICON 26,113,93823,799,00018,935,000
      PHOENIX 49,521,51838,434,95943,685,133
      WAGO 7,076,1526,303,6718,992,308
      INTERMECH 12,034,97716,690,99517,552,873
      SMC 55,589,61764,455,803102,317,790
      ROCKWELL --46,815,627
      SIEMENS -679,874,000542,037,000
      MITSUBISHI -242,890,943219,475,152
      EUTECH -20,034,79317,504,690
      DAIFUKU --14,532,517
      MOTION CONTROL GROUP -652,946961,870
      OMRON -23,090,56518,486,801