How to Show the Last N Months by making use of Parameter?

How to Show the Last N Months by making use of Parameter

How to Show the Last N Months by making use of Parameter?

Explanation

1. First we have to crate the parameter for the N months. As shown below.

How to Show the Last N Months by making use of Parameter

2. Now Drag the Order Date into column self and change year to MY(order date) by right click and select the More options and choose the Month/Year option and click on Apply and then click on OK.

3.Now create the calculation for the Last N months. As shown below.

How to Show the Last N Months by making use of Parameter
4. Now drag that calculation field into filter self and select the TRUE, then click on apply then click on OK.

5. Now change the parameter value then it will show that many number of Months at visualization level, as shown the below output.

How to Show the Last N Months by making use of Parameter

Leave a Reply

Your email address will not be published. Required fields are marked *