Forum Discussion
Analyze in Excel - Date field issue
When using 'Analyze in Excel' Date fields from my model show up in excel as text which really limits the usage of the Analyze in Excel functionality. Has anyone else encountered this and come up with...
It is 2020 and still no solution for this?
A pivot-table with only string values makes the whole "analyze in excel" function pretty obsolet.
I need to be able to sort, filter and sumif sales relative to the date column and a storenumber column. As there will be up to 300.000 rows there is no other option in sight.