Calculating growth

[vijetas42]

Hi,

How should I calculate growth using month data for current and previous like,for example,for feb it should calculate feb-jan likewise show data for all 12 months?

[tresesco]

PFA for sample app.

[#3]

hi

You will have to use Above Function:

Try

RangeSum(sum(Sales),-above(sum(Sales)))/above(sum(Sales))

Himank

[vijetas42]

Thanks,but, can you share just formula

[vijetas42]

Thanks,but this formula is not working with my scenario

[vijetas42]

How this formula works sum( aggr( rangesum( above( sum([IN CRORE]),2,1) ),[FS Month]))?

[tresesco]

Dimension: Month

Expression: Sum(Data)-Above(Sum(Data)))/Above(Sum(Data)

Number Format: 'Show in Percent(%)'

[#8]

Hi

You will have to use Above Function.

Can You attach a Sample File?