Hi,
I've been trying to work this thing out.
I do not know what I've been doing wrong. I am trying to create a pivot table to show a monthly sales report. I wanted to show the figures monthly but the dates aren't cooperating with me. I've already checked the date format it is okay. Whenever I use the filter, it comes up as grouped into dates and even years. But when I create a pivot the dates are appearing individually and I am unable to group them at all.
This is how it appears on my source data.
![1676444055420.png 1676444055420.png](https://exceldemy.com/forum/data/attachments/0/22-6c5edc1a0fccfba8e4595166f1c06323.jpg)
and when I create a pivot it turns into this.
![1676444180111.png 1676444180111.png](https://exceldemy.com/forum/data/attachments/0/23-3ef75ff0f95f0a928681c776c671fb55.jpg)
Please help me
I've been trying to work this thing out.
I do not know what I've been doing wrong. I am trying to create a pivot table to show a monthly sales report. I wanted to show the figures monthly but the dates aren't cooperating with me. I've already checked the date format it is okay. Whenever I use the filter, it comes up as grouped into dates and even years. But when I create a pivot the dates are appearing individually and I am unable to group them at all.
This is how it appears on my source data.
![1676444055420.png 1676444055420.png](https://exceldemy.com/forum/data/attachments/0/22-6c5edc1a0fccfba8e4595166f1c06323.jpg)
and when I create a pivot it turns into this.
![1676444180111.png 1676444180111.png](https://exceldemy.com/forum/data/attachments/0/23-3ef75ff0f95f0a928681c776c671fb55.jpg)
Please help me