Quarter To Date

Previous Member

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,

Kit

Helmut Heimann

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.

 

Kind Regards,

Helmut

Björn Reuber

Hi,

 

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

with

 

regards

Björn

Previous Member

Thanks Björn Reuber Worked like a charm :-)