Date Formatting in pivot table
Date format in Pivot table is not working in filters or in columns/rows. (it has always worked so far, and in this particular case it's not) If I go to the source data, it is a date format. It lists all dates that exist in the data, instead of grouping them by year or by month? So, if I want to exclude or include any particular month, I have to tick or un-tick every single date in that month in filter. Or, the data is not displaying any grouped format in that month. Could you please help? Thank you so much.