Forum Discussion

CCI01's avatar
CCI01
New Contributor
3 years ago

Building a CV with a trailing 5 quarter view

I'm working on a cube view that displays reporting data in a quarterly trend.

The end user would select which quarter they want displayed and the CV would display that quarter along with the 4 previous quarters. 

Ex. User selects 2022Q1 and then CV displays the following columns 2021Q1, 2021Q2, 2021Q3, 2021Q4, 2022Q1.

Data would be displayed quarterly in each column.

Any suggestions on how to write columns based on this criteria?

Thanks.

Cube View
  • PeterFu's avatar
    PeterFu
    3 years ago

    Hi,

     

    You can use the syntax in the print screen below. You select the quarter you want from the parameter that gets prompted. Then you will get the four prior quarters. If you use the Member Filter Builder in the Cube View, then you will find a lot of examples of dynamic references.

     

     

     

    Peter

     

  • PeterFu's avatar
    PeterFu
    Contributor II
    3 years ago

    Hi,

     

    You can use the syntax in the print screen below. You select the quarter you want from the parameter that gets prompted. Then you will get the four prior quarters. If you use the Member Filter Builder in the Cube View, then you will find a lot of examples of dynamic references.

     

     

     

    Peter

     

    • CCI01's avatar
      CCI01
      New Contributor
      3 years ago

      Hey,

       

      Following up on this. How would you write a formula to take the average of the current quarter selected by the user + the prior 4 quarters?

       

      Thanks.

      • PeterFu's avatar
        PeterFu
        Contributor II
        3 years ago

        Hi,

         

        For that you do not need to create any formulas. See print screen below. You can use the members in the View dimension for what you are looking for. You have both 2 - 12 months trailing average and total in the View dimension.

         

         

        Peter