Forum Discussion
RDALE2435
May 12, 2020Copper Contributor
Date formating in a pivot table
I am having a challenge changing the date format in pivot tables. All my table seem to default to year, quarter, month; in lieu of the actual date. While there are times the prior format is useful, n...
AshaKantaSharma
May 13, 2020Iron Contributor
RDALE2435 You can create an additional column in dataset with formula =TEXT(DATE,"DD-MM-YYYY") and use this date format in your PT which will not create any additional dataset in your PT.
Hope this helps.
RDALE2435
May 13, 2020Copper Contributor
Thank you. I will play with that,AshaKantaSharma