I have a flat file that I want to drive a Pivot Table. However, instead of showing values in the Pivot Table Values Box, I want to show text data from the flat file. Basically, I am trying to create a summary cheat sheet with catalog number for our business. Ideally, I would use Slicer to pick either Part Number, UPC code or Inventory. Inventory from a reprot filter and return the appropriate value inside the Pivot table from the values in the flat file. I want to make the table dynamic as inventory changes daily and I would up date the file with inventory number if I pick that fiter. If pick the Cat # filer, i would get the Catg $. My Row Labels I have Colors for the different part numbers and in my Column labels I have 3 different attributes to describe the unique part number. Does anyone suggest I do to solve problem.