scpournara
New Member
- Joined
- Aug 24, 2014
- Messages
- 41
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 Slice to pick either Part Number, UPC code or Inventory. Inventory makes this a dynamic sheet. My Row Labels I have Color and in my Column labels I have 3 different attributes to describe the unique part number. In Values box I ahvCatalog number but in the pivot tables it show the Sum. I want the text. What does anyone suggest I do to solve problem.