Handling continuous changing dates in columns

[#1]

Hi All,

We are developing a dashboard based on one report extracted from tool and it has week start dates in columns for consecutive 8 weeks. The data gets refreshed every week and hence the column name lets say if its 06/09/2013 will change to different date next week that is 13/09/2013. What would be the best approach to handle this kind of data. Can we manage these dynamic columns while designing dashboard.

Kindly give your suggestions.

[alexandros17]

If data are loaded from an xls set labels to Explicit so you will refer to column A, B ... and so on

If you are loading from DB it depends on it but every DB hai its way to refer to column by position and not by name

Hope it help

[#3]

Thanks for the reply. Lets say Date 06/09/13 assinged to Column A, 13/09/13 assigned to column B. The next week when we will upload fresh data the first column in report would be 13/09/13. How will we assign that to column A. And the values which are associated in current report for date 13/09/13 will be associated with that paritcular date even if we refresh data??