Dynamically selecting query items from query subject

[saumil287]

Hi,
The datasource is CSV file.
I am having a table containing columns as BU, Location, Customer, product, Mar-12,Apr-12 and May-12.
The month columns are revenue columns.
Since the current-Month is May-12.
I only want May-12 columns which is based on current-Month & year.

The Final should be
BU, Location, Customer, Product, Current_Month(ie May-12)

Your Guidance is appreciated.

Thanks in advance

[wyconian]

Hi

You need to have some way of identifying which month is the current month.  As this is a csv file you could use another external file which details which is the current month.  You could then have a render variable on the month columns so you only render the column which matches the current month from the new external file.  All the other month columns would be in the report but will not be rendered.

You will need to update the external current month file when you need to change the month.

Another way of doing this would be to have a render variable on the month columns which compares the date against the current system date.  But that would only work if you wanted to see data from the current system date month i.e. it wouldn't work if you ran the report in July but only wanted to see May's data.

As the month columns are columns rather than rows you can't use a standard filter as that would only restrict rows not columns.

Good luck

[saumil287]

Hi wyconian,
Thanks for your reply.
I'll Try and let you know.


Thanks again