Forum Discussion
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. I...
Please see attached, Thank you for looking into this.
Creating Pivot Table add data to data model
Open Power Pivot and add new column Published Months
Add one more column SortMonths
Select Published Months column, Sort by Columns and sort it by latest column
Right click SortMonths column and hide it
Return back to Excel sheet and add Published Months as a filter
Result is in attached file, second PivotTable
Thank you Sergei, Yes, it is working in that way to meet my needs.
Hello,
one last thing
the grouping looks fine ( I'm not sure if this is what you mean-the image below)
