Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Dear Sinan Ozdemir
I can compute the % but nothing shown on the chart, please advise.
Thank you
Tracy
Hi,
Here is your output. Pls find the attached doc.
Edited by : Krishna
Hi:
Before function works only in Pivot table not any other chart. To see the value replace before with above.
Kind Regards,
Bimala