Variance in a Bar Chart

[#1]

Hi,

I'm trying to create a combo chart which shows the % annual growth of sales (like the blue line in the image).

The values on data points aren't that important, my question is how can I make this line.

I tryed use set analysis with current year - current year-1 but doesn't worked.

My idea is to use a Dimension Group with Year and Month to show the variance when the user interact with the chart.

[#2]

Hi,

Try with this:

(sum(Field) - Above(sum(Field))) / Above(Sum(Field))

Above() function gets the previous value.

Regards,

Ricardo

[#3 · Accepted solution]

Use:

=sum(Sales)/above(sum(Sales))-1