Mean percentage growth KPI

[hjoopally]

I have one dimension (month) and one measure (sales) in my data. I calculated % change in sales per month using the following formula in a table chart:

Sum(Sales)/Above(Sum({<[Month]>}Sales)) - 1

I want to add a KPI which measures average monthly percentage change of sales. What's the formula to do that?

Example

Month - Sales - Sales % Change

1 -10 - -

2 -15 - 50%

3 - 18 - 20%

4 - 20 - 11%

KPI: Average = (50+20+11)/3 = 27%

[sidhiq91]

@hjoopally  I just took the Avg([Sales % Change]) and I got the required output. Please see the screen shot.

If this resolves your issue, please like and accept it as a solution.

[hjoopally]

I only have  month and sales in my data. I calculated % change using the formula below:

Sum(Sales)/Above(Sum({<[Month]>}Sales)) - 1

And  Avg(Sum(Sales)/Above(Sum({<[Month]>}Sales)) - 1) is not working.

[sidhiq91]

@hjoopally Please see the below expression to calculate the Percentage % in straight table.

(Sum(Sales)-(Above(Sum(Sales))))/(Above(Sum(Sales)))

To calculate the Avg of Percentages, please the below formula.

Avg(Aggr((Sum(Sales)-(Above(Sum(Sales))))/(Above(Sum(Sales))),Month))

Please remember to set the expression to Number Percentage Format.

I have attached the Screen shot for your references.

If this resolves your issue, please like and accept it as a solution.