Quarter To Date

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
in Platform

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

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    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
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers
    edited March 2020

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

    image

    with

    image

     

    regards

    Björn

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

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

Categories