How do I create a Quarter To Date (QTD) column in a DataView?
I already have current month and Year To Date (YTD).
Thanks in advance,
Hi Kit Chan,
if you've already defined the quarter in the database, you would need another cube for mapping the appropriate quarters to your screen-selection of the relevant year, that's it.
I think you can also get this using the ycv functions (like for ytd, but with setting the cycle to 3 (so it will recalculate every 3 month (my cube is on montly base):
Thanks Björn Reuber Worked like a charm :-)
Retrieving data ...