[EDIT] Thanks, Derk, it's not quite what I was looking for, but it works.
I'm building a pivot table, and hitting a wall.
I have one column of data labled "Status." I need to be able to have rows of my pivot table that summarize only certain codes.
For example, the possible values of "Status" are L, B, and C.
I want a row in my pivot table that is just a sum of all the Ls, another row for Bs, and a third row for Cs.
I thought maybe I could do this with a custom formula, but I have no idea how. I guessed a few things, but nothing is actually returning a sum.
My pivot table should look like this:
If that's too confusing, I'll upload a sample when I get home (the firewall at work blocks it).