maddyyikes
IS-IT--Management
Hi,
I am new to BO and am trying to generate a rolling quarterly report. The universe has a fiscal year and fiscal quarter field (values 1,2,3,4). I would like to know as to how I can generate the current and prior quarters within the cross tab report relative to the current day? Also, when the year changes to a new one it may be required to compare the current year's first quarter with the last quarter of the previous year and the fiscal quarter may not work in this case since it's values run from 1-4 for each year. Any ideas around this?
Thanks in advance
I am new to BO and am trying to generate a rolling quarterly report. The universe has a fiscal year and fiscal quarter field (values 1,2,3,4). I would like to know as to how I can generate the current and prior quarters within the cross tab report relative to the current day? Also, when the year changes to a new one it may be required to compare the current year's first quarter with the last quarter of the previous year and the fiscal quarter may not work in this case since it's values run from 1-4 for each year. Any ideas around this?
Thanks in advance