Displaying a text field in the values section of a pivot table

[PHILLY0041]

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?

 

[Sufiyan97]

Please post your sample data using XL2BB

 

[Sufiyan97]

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?

Drag RFQ# in ROWS field instead VALUES

 

[Misca]

Welcome to the board!

You can't really show text in the values field of a pivot table. With normal pivot tables, that is. But if you're okay with having your text values in multiple row fields, that's a different story.

With Power Pivot you can use measures that return text values. But even that is more like bending the rule instead of breaking it.