How to divide two aggregated field value pivot table - quicksight during expand or collapse?

Question & Answer
11

Hello,
I have figured out the solution.
RATIO ID YEAR LEVEL - sum(v1)/sum(v2)
PERCENTAGE_CHANGE -
percentDifference
(
sum({v1})/sum({v2}),
[{ID} DESC],
1,
[YR,ID]
)

Thank you
Sincerely,

Ticket can be closed!