Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Add % change to column chart

Hi all,

 

I have a column showing average sales per month. However, I would like the chart to show the % change as well month by month like this:

 

 

Is that possible?

 

THanks"!

2 Replies

  • Anonymous  You need to have to use previousmonth  function to calculate the % between the previous month, there are many posts on how to make these kinds of calculations based on time intelligence. The main item is that you have to add calendar dimension in your model which is critical for time intelligence functions. There are many posts on how to add calendar dimensions.