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
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)