Forum Discussion
Pivot Table Yearly Sales Report Issue
I'm currently working on creating a pivot table for a yearly sales report. However, I'm encountering an issue where, after a particular row, the year is not being recognized. This results in an error...
is there a way to directly convert the date to year within the pivot table without having to separately convert the date to year first and then use the pivot table?
Yes and this is auto. done by the PivotTable when the Dates are actual Date values, not your case where your [Date] column contains Text values
In attached file your data has been formatted as Table named SalesData > Routed that table to Power Query to change the [Date] and [Due Date] field types to Date > Build a PivotTable from the query > Added the [Date] field to Rows
==> The Pivot auto grouped the [Date] by Year, Quarter, Month