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

Find more posts tagged with

Accepted answers

All comments

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

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of