The slicer on the sheet reports duplicates the same year 2020.
How can I fix this?
The slicer on the sheet reports duplicates the same year 2020.
How can I fix this?
Last edited by zanshin777; 10-04-2020 at 11:26 AM.
Change the formula in Year column in your data to =YEAR([@[Comp. Date]]), then change the number format of the column to General.
I did that. Then the year looks as 1905. (I did format year column as General)
???
Go to cell J2, press F2 and hit enter. Copy down to the last row.
I found the solution.
That year column is unnecessary.
I deleted that and grouped the pivot table by Years.
Thanks for the answers.
Last edited by zanshin777; 10-04-2020 at 11:47 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks