AdHoc report Help

[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.

If Budget is not available I need to show 12 months of PLAN.

To say clearly 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

[MayilVahanan]

Hi

Please provide screenshot of those

[its_anandrjs]

I was busy in some task if possible provide QVW file and then i let you know.

Regards,
Anand