How to calculate the % of growth YTY.

[#1]

Please find the attached QVW.How can I calculate the % of growth (Inccrase or decrease) of Revenue from Year to year ?

Thanks much.

[sunny_talwar · Accepted solution]

Try like this:

Sum(Revenue)/Above(Sum(Revenue)) - 1

[maheshkuttappa]

Slight change in above expression if you want show % growth while selecting single year

Aggr(Sum({1} Revenue)/Above(Sum({1} Revenue)) - 1,Year)

[sunny_talwar]

Or this, if you need to avoid Aggr() function

(Sum({1}Revenue)/Above(Sum({1}Revenue)) - 1) * Avg(1)