Dynamic columns - with a twist

[herdan]

Hi guys,

I know there are numerous threads explaining how to create a prompt to dynamicaly select the columns of a list.

However, what I want is the following:
Suppose I have a list with columns like this
Customer     2010   2009   2008   2007

Now I want a prompt on years where If I select 2007 all columns are shown, and when I select 2009 only 2010 and 2009 are shown

The same prompt is also used to filter the data of the report

Any help is appreciated

[tupac_rd]

are you looking for a solution to query all the columns anyways and display only columns based on the prompt,

[herdan]

Yes, exactly.