Quicksight Pivot Table doesn't work on calculating differnce after collapse

I want to use collapse in pivot table to show top reason only and show sub-reason only requested by users.
DoD diff in bps is calculated by difference of gv_count% comparing today with yesterday and times 1000. However, it is calculated based on difference of sub-reason. After collapse, I want it to show difference of top-reason dynamically. Is there any way to do that? Thanks


@Yutong_Lin -
I believe you can utilize a approach as shown in the solution to the question in this thread.

Hope that helps!

1 Like