Excel_World
New Member
Hi,
When I click the pivot table data, the drill down data data source format keeps changing. I have one column in the source data file which has the Call Duration.The format for the call duration column is Custom Format as [h]:mm:ss;@. The field in that column shows as 0:21:48 which means as 0 hours, 21 minutes and 48 seconds.The drill down data from the pivot table shows as 12:21:48 AM instead of 0:21:48 . Kindly let me know is there any way to keep the drill down data as Source data format . Thanks for your help.
-Excel_World
When I click the pivot table data, the drill down data data source format keeps changing. I have one column in the source data file which has the Call Duration.The format for the call duration column is Custom Format as [h]:mm:ss;@. The field in that column shows as 0:21:48 which means as 0 hours, 21 minutes and 48 seconds.The drill down data from the pivot table shows as 12:21:48 AM instead of 0:21:48 . Kindly let me know is there any way to keep the drill down data as Source data format . Thanks for your help.
-Excel_World