Growth Rate

[tracycrown]

Dear all

Can someone help to explain why following script does not work in expression ?

Type	2012	2013	2014	2015
Sales	1000	1500	1200	2200
		50%	-20%	83%
(sum(if(Type='Sales',Data))-Before(sum(if(Type='Sales',Data))))/Before(sum(if(Type='Sales',Data)))

Thank you

Tracy

[sinanozdemir]

Hi Tracy,

I tried to mimic your data-set, the if statement works for me. Maybe you have extra space in the type field so try trim() function.

Sum(If(Trim(Type) = 'Sales', Data)) and here is my expression:

If that doesn't work, try set analysis with Sum({<Type={'Sales'}>} Data).

Hope this helps.

[tracycrown]

Dear Sinan Ozdemir

I can compute the % but nothing shown on the chart, please advise.

Thank you

Tracy

[krishna20]

Hi,

Here is your output. Pls find the attached doc.

Edited by : Krishna

[bimala0507]

Hi:

Before function works only in Pivot table not any other chart. To see the value replace before with above.

Kind Regards,

Bimala