Help on Ad - Hoc report

[Anonymous]

Hi All,

I need to create some Ad-Hoc kind of report.In my scenario I will be having list box

i)PLAN/Budget

ii)PLAN

iii)BUDGET

So when User clicks PLAN/BUDGET I need to show the first 6 months of PLAN & Last 6 Months of Budget in pivot table.

In some of cases I may not have Budget value at all. So in that scenario I need to show all 12 months of PLAN Values.

I have enclosed sample data set

Kindly help me on this.

-Jai