Skip navigation

1 Reply Latest reply on Jun 24, 2016 6:50 AM by lenaic.ridinger

How to calculate growth rate(Compared to last month ) by filter

du yingtao May 24, 2016 12:28 AM

source data

month	target	sales	region
12/1/2015	100	90	A
1/1/2016	100	80	A
2/1/2016	100	70	A
3/1/2016	100	90	A
12/1/2015	100	80	B
1/1/2016	100	70	B
2/1/2016	100	90	B
3/1/2016	100	110	B

target table filter by month(Cumulative is option)

filter by month (2/1/2016)

region	grouth rate	reach rate
A	-13%	70%
B	29%	90%

I want to generate scatter plots x grouth rate Y reach rate filter by month (Cumulative is option)

1. Re: How to calculate growth rate(Compared to last month ) by filter

lenaic.ridinger Jun 24, 2016 6:50 AM (in response to du yingtao)
Hi du yingtao,

I'd advise you to check this "How To" Guide about Scatter Plots

You haven't provided us with a workbook, so here is an example I did with your sample data.

Hope it helps!

Yingtao.twbx 10.8 KB
Like Show 0 Likes(0)

Actions

More Like This