Above function

[tellmalaika17]

Hi,

I am trying to get %growth using above function.  I have trade month, tradername as dimension and expression is sum(value).  Using above function in expression (sum(value)-above(sum(value))/above(sum(Value))... This doesn't seem to be working in a line chart. It works in a table but line chart the % nos changes.

Can anyone please assist.

Thanks

[sunny_talwar]

Try this:

(Sum(value) - Aggr(Above(Sum(value)), tradename, month))/Aggr(Above(Sum(value)), tradename, month)

[rupamjyotidas]

Above function would work in Table chart.

sum({<Month={ $(Month-1) }>} Sales))

/sum(Sales) - 1

[tellmalaika17]

Hi Sunny,

Thanks for the reply. Above function will not work in the line chart so this expression is not working.

Tried this in a table chart and it works but not in line chart. 

Is there any other function I can use to get %growth in a line chart.

[tellmalaika17]

Yes works in a table chart. 

[sunny_talwar]

Why would it not work in line chart ? Can you share a sample where it isn't working and I may be able to tweak it to work