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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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