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