Ignore tier 1 rows in Excel pivot tables
<p>I have a pivot table in Excel, and I'm trying to do some calculations on the results. This is all fine and good, but I'm running into a problem due to the grouping of a pivot table.</p>

<p>I have a dataset indicating transaction history for a particular client/patient at a vet clinic. These are reflected by clientID and patient name in my pivot table. I've used a pivot table to group by client then patient to see when the first purchase was made and how many total purchases there have been. I want to then do a calculation on that for each patient.</p>

<p>My problem is here. Excel has all the data for each client grouped in what I'll call "tier 1 results". The only data I want to do the calculation on are the "tier 2 results". These are row 7 and then rows 8-9 in the screenshot below.</p>

<p><a href="https://i.stack.imgur.com/rExgU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rExgU.png" alt="Pivot table screenshot"></a></p>

<p>In effect, I wan to include something in the equation in column F to ignore any bold text, but Excel doesn't appear to be able to do this. VBA is an obvious solution for me, but I'm creating steps for salespeople to use to analyze the data while they're out in the field. We need to keep things as simple as possible. Copying and pasting an in-cell equation is one thing, but using VBA is way over their heads.</p>

<p>Any thoughts on how to ignore the tier 1 results?</p>