Fiscal year calcsulation

[EArumugam]

Hi All,

In my report i am having date range prompt. if the user selects date more than year (for eg: from:01 Jan ,2008 to: 27 Oct 2009) the calculation done based on the year level.

take sales report as example.

if i select above mentioned date range.

my o/p will come like ...

Year    Prod       Sales
2008    XXX        100 (01/01/2008 to 31/12/2008)
2009    XXX          50 (01/01/2009 to 27/10/2009)

how can i achive this.

please reply back if above is not understandable.

Thanks in advance

[VisioX]

One way would be "group by" in sql.

In case of a crosstab:
If you don't have it, build a calendar-hierarchy and drag 'year' into the row. (don't forget to create a relationship inside FM between the calendar and your table)