[Answered] Unable to group dates in Excel Pivot

This thread is solved

stlmrs05

New member
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


and when I create a pivot it turns into this.

1676444180111.png


Please help me
 
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
 
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
 
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
 

Online statistics

Members online
0
Guests online
11
Total visitors
11

Forum statistics

Threads
287
Messages
1,240
Members
508
Latest member
HaroldDyeme
Top