title: How to get % of subtotal in Quicksight Pivot Table
body: <p>I am creating a pivot table for leads a brokerage received in a county - I am trying to show the market share for each brokerage so I want to divide the leads a brokerage received by the total leads in the county. I was wondering if there is a way to divide based on the subtotal for each county.</p>