adding columns dynamically to report

[arusanah]

Hi ,

I'm creating a report to display monthly customer sale .

My requirement is to have flexibility to select date range . and based on that range it should add columns to table or Pivot report.

I know we need two input boxes for  from date and to date.but then dont know how to generate runtime columns in report .

e.g Product category , Productn description , <n months customer sales >

pls help

[Anonymous]

You can mark only one answer as correct.  You've marked mine as "helpful" - good enough

[arusanah]

Hi Ramon

i tried creating calculated Dimension whatz happening is it creates addition columns . e.g i selected date range as mar 2014-  dec 2014.

it creates columns for 2015 also , looks like it disregards the selection . Can you help me with this