Two Calender wise analysis in one Report

[#1]

Hello,

I want two calender (Financial Calender as well as Normal Calender ) wise analysis in one report :

Expression :sum(sales) Dimension: MonthYear

i.e When I am selecting calender month or year then I want sales according to Calender MonthYear

and when I am selecting financial month or year then I want sales according to Financial Month Year.

Kindly Help me,

Thanks in advance.

[maneshkhottcpl]

Hi Yogesh,

Please share ur sample application with requirment.

[#3]

Hi Yogesh,

please see the attached example for help (Script part).

Good luck!

Rainer

[#4]

Hi Rainer,

Thank u for quick reply.

But My requirement is :

There is one indication or List Box having Normal Calender (Jan to Dec ) and Financial Calender (Apr to Mar)

When I am Selecting Normal Calender, Chart will show Sales according to Month (Sorting Jan to Dec)

When I am Selecting Financial Calender, Chart will show Sales according to Month (Sorting Apr to March)

If any doubt, Please reply.

[Anonymous]

Hi Yogesh,

I solved this by using 2 seperat calanders, one connected to one date-field the other to an other.
Is this what you are looking for?