Getting Column Names

[#1]

Hi,

     I have a table where the columns keep changing based on the current month.Which is if I have Sep as me current month then

     columns will start from Sep 2011(if sep is current month) to Aug 2012.

     I have to populate a straight table based on these columns and now these columns cannot be static as the column names keep changing

     for every month.

     Could you please suggest a way where I can populate the Grid so that no matter the column names change I need the staright5 table getting populated

     with the field names present in the table (though the field names aree changing).

Regards

Navin.G

[sridhar240784]

Navin,

Insted of using Straight table, use pivot table and month should be as Dimension. Drag this month to the end of the pivot table toward right horizontally.

-Sridhar

[#3]

Hi Sridhar,

               Thanks man Thanks a lot this was what I needed.My only issue now is these columns

               i.e.Sep 2011 Oct 2011...Feb 2013 need to be aranged in an order.Instead I am getting the foll

               May 2012  Jun2011 Dec 2012........Actually they do not follow any order as such.

               Could you suggest a way to arrange them in an order.

               Some thing like :Sep 2011 Oct 2011 Nov 2011....Feb 2013

Regards

Navin.G

[sridhar240784]

Navin,

Are you loading these Month as a text? if So try to convert it as date and extract month from it. it wil automatically work.

-Sridhar