I have a worksheet that keeps track of forms we use when we visit one of our clients. They are broken out by zip code with packets created for each zip code. I have a pivot table that breaks out the packets by which staff member has them, or if the packets have been created but are unassigned. If the cell is blank it means no packet has been created.
The issue is that no packet created shows up as (blank) in the pivot table row labels. I can manually type in "No Packet" into the pivot table, but it then makes that label a permanent part of the filter list, so the next time I refresh the pivot table the (blank) shows up again plus I have a choice in the filter of No Packet. I can't manually add the same label to the (blank) row because it already exists.
Is there a way to give blank cells the row label of No Packet in the pivot table without having to go through the data set and entering No Packet in each row?
Here is how the data shows up in the pivot table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]AIDE[/TD]
[TD]#packets turned in[/TD]
[TD]# packets out[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD]219[/TD]
[TD]69[/TD]
[/TR]
[TR]
[TD]Sal[/TD]
[TD]194[/TD]
[TD]61[/TD]
[/TR]
[TR]
[TD]Cheryl[/TD]
[TD]0[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]Unassigned[/TD]
[TD]0[/TD]
[TD]96[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD]0[/TD]
[TD]15[/TD]
[/TR]
</tbody>[/TABLE]
While I can remember that (blank) means no packet has been created, the people who I share this table with can't. I'd rather not have to go in and put "No Packet" in the individual cells, but can't figure out a way to have Excel refer to the blank cells as "No Packet"
Thanks!
The issue is that no packet created shows up as (blank) in the pivot table row labels. I can manually type in "No Packet" into the pivot table, but it then makes that label a permanent part of the filter list, so the next time I refresh the pivot table the (blank) shows up again plus I have a choice in the filter of No Packet. I can't manually add the same label to the (blank) row because it already exists.
Is there a way to give blank cells the row label of No Packet in the pivot table without having to go through the data set and entering No Packet in each row?
Here is how the data shows up in the pivot table:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]AIDE[/TD]
[TD]#packets turned in[/TD]
[TD]# packets out[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD]219[/TD]
[TD]69[/TD]
[/TR]
[TR]
[TD]Sal[/TD]
[TD]194[/TD]
[TD]61[/TD]
[/TR]
[TR]
[TD]Cheryl[/TD]
[TD]0[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]Unassigned[/TD]
[TD]0[/TD]
[TD]96[/TD]
[/TR]
[TR]
[TD](blank)[/TD]
[TD]0[/TD]
[TD]15[/TD]
[/TR]
</tbody>[/TABLE]
While I can remember that (blank) means no packet has been created, the people who I share this table with can't. I'd rather not have to go in and put "No Packet" in the individual cells, but can't figure out a way to have Excel refer to the blank cells as "No Packet"
Thanks!