Combining Sales of two months

[#1]

Dear Community,

sorry it must be a really stupid question but i try to have a simple table that Shows month, Sales, and Sales/Sales of next months in the same line.

I just cannot get it 😞

Anyone that can briefly help?

Cheers

Seb

i.e.

Month     Sales     Sales/Sales next month

Apr          1000     200%

May          500     100%

June          500    

[christophebrault · Accepted solution]

Hi,

try this expression :

sum(Sales)/Below(sum(Sales),1,1)

[#3]

Thanx christophe - this helped for now

[christophebrault]

This solution isn't matching exactly your needs ?

[#5]

yes it indeed did - thanx a lot again.

[christophebrault]

Ok, no problem.

Just a tip for the Qlik Community :

Turn to green when your problem is solved.

Bye