4 Replies Latest reply on Jan 9, 2019 6:52 AM by Esther Choy

# Percent Changes with Indicators

Hello All,

I'm trying to create a visual indicator (green or red arrows) that will show the percent change for each row.

For example, Product A is 0.1% of it's total for 2005-2007 and increased to 0.3% of it's total for 2015-2018.

Any assistance appreciated.

 2005-2007 2015-2018 A 3 0.1% 9 0.3% B 36 1.2% 43 1.3% C 298 9.9% 336 10.4% D 2667 88.8% 2834 88.0% Total 3004 3222
• ###### 1. Re: Percent Changes with Indicators

Hi Esther,

It can be done in many ways

1) Using Look up Calculation

2) Using Separate calculation

3) Using Difference

Could you please attach a sample workbook so that it will be easy to understand your data and provide the solution.

Regards,

NB

• ###### 2. Re: Percent Changes with Indicators

See attached for sample workbook.

Thanks!

• ###### 3. Re: Percent Changes with Indicators

Hi Esther,

Do you mean like this ?

I didn't bother with the accuracy of the calculation because I just made them up, but if you drop this onto your viz and then change the mark to shape, this will add a shape mark to your viz. You can then enhance this by adding a number or some text around it using the label mark as well as adjusting the shape to anything you need.

HTH 10.2 attached

Peter

• ###### 4. Re: Percent Changes with Indicators

I'm really look for something like this:

For item A - would like a green arrow showing that the percent increased from 0.1% to 0.3%