Need help changing Pivot Table field to Date format (data coming from Cube)

Occasional Visitor

Hello There,


I am trying to get dynamic date filtering for my pivots, but my date fields are not in date format. My data is coming from a cube pulling from SQL.


When I click field settings on the date fields, the "number format" button is not showing only "filter", so I am unable to change the format. 


I have the date field in my "rows" section of the pivot





0 Replies