PHILLY0041
New Member
- Joined
- Jan 27, 2021
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
I am working on a pivot table that summarizes a table of quotes by year, month and customer.
In the table I have items like "Customer", "RFQ #", "RFQ_Value", Response_Date", and I also have fields like "Associated_Part_Number" and "Contract_Number" that are alphanumeric.
As a reference item in the piviot table I want to show the "Associated_Part_Number" that corresponds with the RFQ number in the values section but it is text only. Is there a way to use a "calculated field" that will basically just print what is shown in a cell of my table in the values section without it being a number?
In the table I have items like "Customer", "RFQ #", "RFQ_Value", Response_Date", and I also have fields like "Associated_Part_Number" and "Contract_Number" that are alphanumeric.
As a reference item in the piviot table I want to show the "Associated_Part_Number" that corresponds with the RFQ number in the values section but it is text only. Is there a way to use a "calculated field" that will basically just print what is shown in a cell of my table in the values section without it being a number?