[Answered] Unable to group dates in Excel Pivot

[stlmrs05]

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.




and when I create a pivot it turns into this.




Please help me

 

[stlmrs05]

It's okay now, I've figured it out

 

[shamimarita]

It's okay now, I've figured it out

Hi, stlmrs05!

That's amazing. You have figured it out by yourself. If you face any Excel-related problems again, feel free to post them in the forum.

Regards
Shamima
Moderator | ExcelDemy - Forum

 

[kingfaisal0786]

Pivot table in two same account no and different value and Address
exp
1st account no 0876500087600021-56.89-jaipur
2nd account no 0876500087600021-76.90-churu
this show on pilot table
so please guide

 

[Yousuf Shovon]

Pivot table in two same account no and different value and Address
exp
1st account no 0876500087600021-56.89-jaipur
2nd account no 0876500087600021-76.90-churu
this show on pilot table
so please guide

Dear Faisal,

Welcome to ExcelDemy forum! I am having trouble understanding your requirements. Care to explain a little more so everyone would have an idea as to what your problem is? Might be worth uploading the workbook with detailed instructions on how to recreate it. Thank you.

Best Regards,
Yousuf Shovon