3 Replies Latest reply on Nov 14, 2017 9:18 AM by Manuel Velasquez

# mom change and 3 month change display in dashboard

Hi, i have created 3 month over change as below using formula.

(ZN(SUM([cat_a_approved_limits])) - LOOKUP(ZN(SUM([cat_a_approved_limits])), -3)) / LOOKUP(ZN(SUM([cat_a_approved_limits])), -3)

but I want to display only the current and under that the change % as show below and remove the before 3 months. how can I do it? if I remove the date month(date) filter I'm not getting any percentage for the metrics. can some one please advise or help me the way to only display the current month and under that the % change.

or is their any LOD calculation or any other formula to calculate the change using the year and month of the date column.

• ###### 1. Re: mom change and 3 month change display in dashboard

Hi Sowjanya

Let me show you one way you can get the result you are looking.

For this example, I'm using "Sample-Superstore" data set

I'll create a view to show sales per month per each region.

I'll add a filter on YEAR(Order Date) to show data only for 2017

Now, I'll apply a Quick Table Calculation % difference

I'll add another instance of SUM(Sales) just to show the actual values and % at the same time

Then you can play with the position of the blue and green pills to change the layout of the view

Then I'm hiding the columns I do not want to show, by multiselection and then right click

To display the sales value and then the % I'm just moving the Quick Table Calculation from "Measure Values" Card to "Text"

Attached .twbx file for reference

Let me know if this helps!

Manuel Velasquez

• ###### 2. Re: mom change and 3 month change display in dashboard

Hi Manuel,

yes this worked for me. thanks a lot.

1 of 1 people found this helpful
• ###### 3. Re: mom change and 3 month change display in dashboard

Hi Sowjanya

I'm glad to hear that this approach helped you if this answered your question when you have time, please mark that answer as correct so other users can refer to this.

Have a great day!

Manuel Velasq[uez