Create % of unfiltered total in Excel
If you create a Pivot Table with your data, use Column 1 and Column 2 for your Row Labels and Column 3 for your values and it'll automatically subtotal and total your values for you.
The left table shows your base data. The middle table shows unfiltered data. The right table shows your data filtered >1 (without the percentage format applied).
