Updating column date format in pivot view
I'd like to change the date format of the columns in a pivot view, but when I click on the field in the design view, I get the following message : "
You cannot remove this column, as there is a dependent column xxx
in Data field".
Does it mean I have to delete and recreate the data fields in order to update the date format ?