I'm trying to add a computed field to a Pivottable for Month/1/Year. The data used to create the Pivot only has columns for Month and Year. I need to group the data by MM/YY so I tried to add a formula field month_date&"/1/"&year_date but it displays it as a SUM of MyFieldname with #VALUE! for the cell values.
The version is Excel 2007.