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