Dynamic Selection of Columns

Using dynamic selection we can change the columns whatever we want to to see in the report requirement......

1. Pull the data Country, City from the Source
2. Drag a Query calculation & define as

case ?Choice?
when 'C1' then 'Name'
when 'C2' then 'Mail'
else
'Fax'
end

3. Drag a value prompt & add C1 & C2

4. Run the Report.....