BookmarkSubscribeRSS Feed
jrmathieu
Fluorite | Level 6
We have several pivot tables using the Add-in where when selecting a cell to drill-thru for details will only provide the date by default as a number.

We must reformat it in the worksheet each time to display the date properly.

If the variable is display in the pivot table, it is displayed as date.

What is missing to enable auto formatting for the cell drill-thru detail to provided date variables as dates ?

What format (or not) should the date variables be ?
We have contacted tech support on this question and never recieved an response that has solved our problem. Message was edited by: jrmathieu
1 REPLY 1
jrmathieu
Fluorite | Level 6
Is there any best practices to use for dates within the Add-in, Excel and pivot tables ?
Thank you,
John Mathieu

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 835 views
  • 0 likes
  • 1 in conversation