Addition to a Pivot Table

[Robert_Conklin]

Good evening. I am using Excel to track the progress of supplier onboarding. I have a cell that calculates the # of days elapsed using the following formula;

=IF([@[LAST ACTIONING DATE]]="","",TODAY()-[@[LAST ACTIONING DATE]])

I also have conditional formatting set up to change the text bold red if the count is greater than 14 days.

Here is the ask...I am trying to add this information to a pivot table but when I add the column to the "Values", it does not show the data. I tried formatting the cells as "Number" and still doesn't work with the "General" formatting. Any help would be greatly appreciated!!

 

[felixstraube]

Can you show us a sample of your data? I think this should work just fine.

 

[Robert_Conklin]

VN	SUPPLIER NAME	ACM_ID	SM_ID - ARIBA	IS SUPPLIER IN ARIBA?	STAKEHOLDER	CATEGORY	SOURCING OWNER	LAST ACTIONING DATE	# OF DAYS ELAPSED
0001079188	DOCU SIGN INC	ACM_10866767	S43043622	YES	ALEX BRASHER	IT / CONSULTING	ALEX BRASHER	12/1/2023	14
0001033459	KPMG, LLP	ACM_12010362	S45844952	YES	ALEX BRASHER	IT / CONSULTING	ALEX BRASHER	12/14/2023	1

 

[felixstraube]

I have created a table with your data and a pivot table, and it works just fine.

Is it something with your formating maybe? why do your sample have so many cells and rectancles in another rectangle?

Mine just looks like this:

Libro1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	VN	SUPPLIER NAME	ACM_ID	SM_ID - ARIBA	IS SUPPLIER IN ARIBA?	STAKEHOLDER	CATEGORY	SOURCING OWNER	LAST ACTIONING DATE	# OF DAYS ELAPSED
2	1079188	DOCU SIGN INC	ACM_10866767	S43043622	YES	ALEX BRASHER	IT / CONSULTING	ALEX BRASHER	01/12/2023	17		Etiquetas de fila	Suma de # OF DAYS ELAPSED
3	1033459	KPMG, LLP	ACM_12010362	S45844952	YES	ALEX BRASHER	IT / CONSULTING	ALEX BRASHER	14/12/2023	4		DOCU SIGN INC	17
4												KPMG, LLP	4
5												Total general	21
Hoja1

Cell Formulas
Range	Formula
J2:J3	J2	=IF([@[LAST ACTIONING DATE]]="","",TODAY()-[@[LAST ACTIONING DATE]])

 

[Robert_Conklin]

I just added a table from the menu and copy/pasted my info into it. Not sure why you are seeing all of it. Did you copy the same formatting I described in my original post? Would it be easier to email my original copy to you/.

 

[felixstraube]

Can you share your bb code? Or upload the excel somewhere and share the link here?

 

[Robert_Conklin]

bb code?

 

[Robert_Conklin]

If figured it out. It has something to do with the conditional formatting I had set up in the worksheet that prevented the correct figures from showing up in the pivot table. I removed the conditional formatting in the worksheet. Added the values to the pivot. Then set the conditional formatting back up. It works fine now. Thank you for your time.

 

[felixstraube]

Glad you could solve it.