Last Full Quarter and Last Full Year

[bonniehsueh]

Hi All -
I need to create a report that shows Last Full Quarter and Last Full Year.

User selects an end date from values below. For example, when the user selects 200907, that is in the middle of Q3 so the last full quarter is Q2. Q2 sales should be shown.

The data elements I have to work with look like below. Unfortunately I do not have the option to add additional values like first of the quarter.

200908
200907
200906
.....
200808
200807
200806
.....
200708
200707
200706
...

Any ideas would be appreciated.

Thanks!

[billylodz]

cube ?

http://www.cognoise.com/community/index.php/topic,4815.msg16862.html#msg16862

[bonniehsueh]

Yes there are functions when using a dimensional data source. However, this is a relational data source.

Thoughts on the calculation when using relational data?

Thanks in advance!

[VisioX]

Might sound complicated but try this...

Split you "quarter" into two fields (year/month), divide the month by three and cut off the decimals, add one to the result and take that as your start month (+2 more to get the full quarter). If the result is negative, subtract one from your year and make your month = 10.