I want to use the Pivot to create  sheet of values in the past 7 days.

I use "Areas" as columns, rows with date but when I put a text field - string in the data, it wants to count it.  Is there a way to just display the value?