Column Returns Value Based on ISBLANK / COUNTS ALL CELLS IN PIVOT TABLE

[kraamerica]

I have a pivot table I'm trying to insert but it's capturing all the cells in the worksheet column I'm pointing to. That cell has =IF(ISBLANK(G2),"OUSTANDING","RECOVERED") from the data in G2. I have the if set up to return the 2 values (which it does), but again, all the cells are being counted. I tried "" instead of recovered but I'm guessing that is not a blank cell due to "" being the value returned.

I don't know if it matters, but g2 points to a validation list that will return the value as blank or a value so I'm not sure that is the issue? I also tried to insert a calculation field in the pivot table to subract a total count - recovered count to calculate the outstanding #. I'm trying to the xl2bb add-in, but even following the help directions of trust center and even rebooting with no luck. I'll keep trying but wasn't sure this was enough to get me an answer until I can figure out and giving me the grayed out section (I have tried the XL2BB Icons greyed out post).

 

[kraamerica]

I have a pivot table I'm trying to insert but it's capturing all the cells in the worksheet column I'm pointing to. That cell has =IF(ISBLANK(G2),"OUSTANDING","RECOVERED") from the data in G2. I have the if set up to return the 2 values (which it does), but again, all the cells are being counted. I tried "" instead of recovered but I'm guessing that is not a blank cell due to "" being the value returned.

I don't know if it matters, but g2 points to a validation list that will return the value as blank or a value so I'm not sure that is the issue? I also tried to insert a calculation field in the pivot table to subract a total count - recovered count to calculate the outstanding #. I'm trying to the xl2bb add-in, but even following the help directions of trust center and even rebooting with no luck. I'll keep trying but wasn't sure this was enough to get me an answer until I can figure out and giving me the grayed out section (I have tried the XL2BB Icons greyed out post).

I was able to install on another computer so here is the mini sheet:

Edison Query Outstanding_Recovered Units 2025.xlsx
	A	B	C	D	E	F	G	H	I
1	DM	TPM	Ship to Location	ESN	Order Date	Total Count	Recovered (Status)	CABLE STATUS	STATUS
2	JOE SOLOMON	JOE SOLOMON	A&M Automotive	10:010030012413469	11/22/2024	1			OUSTANDING
3	JOE SOLOMON	JOE SOLOMON	A&M Automotive	10:010030012413943	11/22/2024	1	ORLANDO	GREEN	RECOVERED
Suzanne_Recovered

Cell Formulas
Range	Formula
I2:I3	I2	=IF(ISBLANK(G2),"OUSTANDING","RECOVERED")

Cells with Data Validation
Cell	Allow	Criteria
G2:G90	List	=$Z$2
H2:H19	List	=$AA$2:$AA$5

 

[kraamerica]

I figured this out. I created 3 separate status columns and deleted the blanks as I had the IFBLANK set to return the status or "".