I am having an issue with the date format. The raw data is the format as mm/dd/yyyy, but when I pivot (and group by month), the date shown as dd-mmm.
The field setting format as a mm/dd/yyyy, but it is still showing as dd-mmm.
Hope there is a way to fix this problem.
I've also attached a snippet.
Thank you!
Bookmarks