Hi Everyone,
I have been stuck and couldn’t find the best expression to measure rebooking trend (Year2-Year1+1) for the max sum amount.
Referring to table below, I want to measure year gap of the max sum booking.
![supiah_0-1693798228451.png supiah_0-1693798228451.png](https://community.qlik.com/t5/image/serverpage/image-id/115621iEEF5F1FA5F95F1FE/image-size/medium?v=v2&px=400)
The result should be like below:
![supiah_1-1693798252655.png supiah_1-1693798252655.png](https://community.qlik.com/t5/image/serverpage/image-id/115622i57E99418D93E1872/image-size/medium?v=v2&px=400)
It would be great if someone can help with this issue.
Thank you.