How to add improvement percentage calculation field?

Hi Team

I have created one dashboard to show one metric at weekly basis, using pivot table in Quicksight.

I would want to add the metric improvement percentage:

improvement% = [metric(WeekN) - metric (WeekN-1)]/metric (WeekN-1)

How to add improvement percentage calculation field?

How to write correct syntax to showcase the improvement% in the pivot table?

— [Is there any possible to create a dropdown while selecting the week number then the improvement% can be automatically reflected?]

Thank you.

Hi @liu_weiwei

Have you looked at periodOverPeriodPercentDifference?