I have two Custom fields that are derived from a date field in the list. These fields show up fine when exporting the list to Excel, but when added to an axis in a Pivot table data connection, come up blank.
Are custom fields capable of being passed to Pivot tables? If not, has anyone overcome this with Workflows? It seems like overkill for something as simple as stripping the day out of a date field, but I'm not sure what other choice there is.