I need to create an expression as (x-above(x))/above(x) in grid chart.

[#1]

I need to create an expression as (x-above(x))/above(x) in grid chart.

Month Region Sales

Jan US 1000

Feb US 2000

Mar US 2020

Jan EU 1000

Feb EU 2000

Mar EU 2020

Jan AS 1000

Feb AS 2000

Mar AS 2020

IMPORTANT - X-Axis is Dimention is Month, Y-Axis is Region. The function above calculates above based on Region. I want it by Month. i.e. % Change in Sales by Month. It works if month is on y axis and region on x axis but I want month on x axis and region on y axis

[israrkhan]

You need to use Before() function, in this case...

Like = (Sale - Before(Sale)) / Before(Sale)

[SunilChauhan]

use in script

( (Sale - peek(Sale)) / peek(Sale))  as My expression

or

( (Sale - above(Sale)) / above(Sale))  in expression directly