Percentage difference with previous record in Pivot table

[stats101]

Hi,

I'm wanting to calculate the year on year percentage difference in a pivot table (structure below). I suspect I need to use a set analysis expression? Any help is appreciated.

Thanks

[sunny_talwar · Accepted solution]

Try Above(Accident_Index)

Edit: Previous is a script only function and cannot be used in the front end of the application. Check out the link: http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/InterRecordFunction...

Best,

Sunny