I have seen several postings for quarterly reporting but I dont think they resolve my issue.
There is an existing report - Purchase Order Summary by Material.
The user wants it by quarter instead of cal month/year which he is currently receiving.
I only see variable for current quarter and prev quarter.
Loaded to the cube are the following time characteristics;
I would like to not have to use CMOD if possible.
The two reported key figures per month are gr value and gr qty.
I just created a custom variable for month1 (01/2010) and I can create offsets for each month and then formulas to capture qtr1, qtr2, qtr3 and qtr4 but I am thinking there might be a better and more efficient way.
Report currently comes out as;
material plant vendor gr value 01/2010 gr qty 01/2010 gr value 02/2010 gr qty 02/2010 etc
I would like;
material plant vendor gr value qtr1 gr qty qtr1 gr value qtr2 gr qty qtr2 etc
Thanks for any help you can provide.