I created a pivot table using 2007 Ms Excel. On the column level my data is only calculated in different aggregated functions. Is there a way to turn off these aggregated functions. My date shows as count as well. How do I make this normal because even with format cells and changing the setting to date it shows absurd date.
Thanks in advance