[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.
Table Sample:
Month______Status______Closed
Jan__________L__________Feb
Jan__________B__________Open
Jan__________L__________Jan
Feb__________C_________Feb
Feb__________L_________Feb
My pivot table should look like this:
Month______Jan______Feb
Total________3_______2
L___________2_______1
B___________1_______0
C___________0_______1
If that's too confusing, I'll upload a sample when I get home (the firewall at work blocks it).