Thank you sooo much for this! I felt like I'd lost my mind when my dates stopped grouping automatically. Your video saved me from a reporting pickle. Hope you're well! thanks again!
Very good guidance on solving my problem with large data that i couldn't group the date that look exactly like a date!. The text to column solved the mystery. Thanks!
Companies that work on a fiscal calendar year instead of a normal calendar year is my special period issue. Unless there is another way? This will work! Thank you!
Thank you my friend! Good stuff! IVery much like your sense of humor. Please allow me to share one more simple way of doing "Only Month" without vlookup, by using formula "=datevalue(A2&1)"🙂
You're cocky 😝 but very very good 👍. Thanks for saving me. I've spent an entire day trying to fix this. You're the best. I've done myself a favor by subscribing to your channel. Thanks 🙏 once again. Mmmmuuuuuaaaaaaa 😘💋
Great video! I do not like approximate match, as I do not know the algorithm and the result may be unexpected. Also, i need something, to give me weekly timeline with missing datapoints filled with zeros. Group by 7 days creates insanely long data labels for horizontal axis for chart. Last resort is to merge datapoint dates with generated simple calendar with all dates in power query.
does this work the same when your source table is crosstabbed by date (dates are the column headers, not a column value)? i cant seem to group my column headers as they are showing as "sum of" fields even though nothing is being grouped
If in my dates column I have some cells where the dates is not available so they are empty, how can I group them in Pivot table? Cause it keeps telling me the error "Cannot group this field"
Thanks for the vid! Can you also teach me how to prevent pivot table from undoing my default cell background? Mine is GRay, and it keeps on removing cells below the pviot table every time I filter it. I've notice that yours is not changing, or perhaps you only removed gridlines? thanks!
I have a file containing data and a column of date rows, but no matter what I do; Excel refuses to group. Tried everything: the settings in options to allow/disallow automatic grouping, going trough all of my cells to make sure they are dates, do the text-to-columns conversion thingy to dates, ... nothing helps. :(
on the pivot range i have formula, due to which i am not able to group per month and year wise, kindly help to overcome it sir, very often i need to change the data range only then it is working
Hi, I have a problem in pivot table date grouping. Before the date grouping in the pivot table, the date is a number e.g. 44186 (12/21/2020). However, when I dragged it to the pivot table, and then to group it into year, quarter, month and date. The date format is changed from a number to a text “Dec-21”. I have no idea why it is changed to text, and how can I keep it in number unchanged? I hope I make myself clear and you understand what my problem is. Thanks.
Nice video, thanks! you cover everything there, though... and you mightfind this one interesting... I have the case where dates are correctly recognised as such in the source data, with proper format,but get screwed up in the pivot table. I am thinking that might be linked to the fact that I have excel set for US formatting and need to enter dates values as M/D/Y but I formated the dates in the source data to be shown as DD-MM-YY (way more logical it feels). Any ideas or tips you may have there? struggling for quite some time on this now... THANKS!
![ถามตรงๆ กับ อาจตุพร ทำไม ประเทศไทย ใครเป็นนายก ก็โดนด่า พอออกเเล้วคนคิดถึง!!?? l [Nickynachat]](http://i.ytimg.com/vi/3YFLMXxBGAs/mqdefault.jpg)
Incredible. How the command "Text to Columns" fixes the date issue is beyond me, but it worked. I was about to go insane fixing it.
Bro that text to columns move is insane!! Fixed my whole model thanks!!!!
i was really mad & angry trying to solve this problem , that trick Text to columns saved me, thank you from morocco 😛
Was struggling for hours with an export that would not group who knew text to columns would fix it, You are a life saver best video ever!!
Thank you sooo much for this! I felt like I'd lost my mind when my dates stopped grouping automatically. Your video saved me from a reporting pickle.
Hope you're well! thanks again!
Hands down to you my brother, you win the Internet Today!!!!! Best Tutorial ever
Very good guidance on solving my problem with large data that i couldn't group the date that look exactly like a date!. The text to column solved the mystery. Thanks!
Wow! that was simply awesome - the flow, the content, and the help I got from this video. Thanks for the video!
This Video is simply awsome, i got one issue in my excel but cleared with your video. thats wow.
Thank you very much😇, you help me to solve my problem with my data. it was a nightmare since 2 days to find a solution with my 10000 rows 🧐🤓
Best explanation on the entire internet!
Thank you very much. I've been stuck in the error for an hour without any clue...
Très intéressant merci
Thanks for the excellent guidelines.
Companies that work on a fiscal calendar year instead of a normal calendar year is my special period issue. Unless there is another way? This will work! Thank you!
Thanks for the video. I finally solved my errors in grouping a date :)
thank you very much the text column was the answer to my problem.
My problem solved Thank you
Thank you my friend! Good stuff! IVery much like your sense of humor. Please allow me to share one more simple way of doing "Only Month" without vlookup, by using formula "=datevalue(A2&1)"🙂
Text to column did it for me. Thank you so much!
Got solution in a minute...... thank you
You're cocky 😝 but very very good 👍. Thanks for saving me. I've spent an entire day trying to fix this. You're the best. I've done myself a favor by subscribing to your channel. Thanks 🙏 once again.
Mmmmuuuuuaaaaaaa 😘💋
Just Brilliant
nice really helped me
Text to Columns...unbelievable! (after all these years....uuuggg) Cheers
This is great. Can you also show how to group the dates when we actually put date in filter segment of a pivot table?
This is a Masterpiece..Thanks for sharing knowledge
very usefull thank you
THANKS BROTHER NOW IT IS OK!!!!! THANKS A LOT FOR OUR TUTORIAL!!!!
This video helped me a lot!! Thank you so much!!!
Excellent Flow, thank you!!
very helpful
Y're a GENIUS!!!!.......GOD BLESS YOU!!!
Thanks man
life Saver video, thanks a lot!
Ultimate Tutorial ..was very much helpful
Well explained .Thanks
text to column fixed my issue. thanks
thanks very much for sharing this. you definetely saved my day
THANK YOUUUUU
Great video! I do not like approximate match, as I do not know the algorithm and the result may be unexpected. Also, i need something, to give me weekly timeline with missing datapoints filled with zeros. Group by 7 days creates insanely long data labels for horizontal axis for chart.
Last resort is to merge datapoint dates with generated simple calendar with all dates in power query.
does this work the same when your source table is crosstabbed by date (dates are the column headers, not a column value)? i cant seem to group my column headers as they are showing as "sum of" fields even though nothing is being grouped
You are amazing!!! Thank you so much
Awesome video man
Helped immensely, thank you!
YOU are AWESOME, thank you so MUCH!
You're a genius!!!
You're a star! 👍
hi! is it possible to have a date filter after grouping the dates by years? thanks. i can't move on with this error.
So helpful, thank you!
I can do this easily in the local app. But the online version does not show a [Group] option in the right-click menu. What now?
Thank you so much
If in my dates column I have some cells where the dates is not available so they are empty, how can I group them in Pivot table? Cause it keeps telling me the error "Cannot group this field"
IT WORKED THANKS
you are the man!
Holy crap the audio difference between your voice over and brand intro is insane - I nearly had a heart attack. Good video though.
Thank you SOOOOOOOOOOOOOOOOOO much, you saved me.
Legend
Oh my god! Thank you so much
thank you , that was very helpful
Thanks for the vid! Can you also teach me how to prevent pivot table from undoing my default cell background? Mine is GRay, and it keeps on removing cells below the pviot table every time I filter it. I've notice that yours is not changing, or perhaps you only removed gridlines? thanks!
I have a file containing data and a column of date rows, but no matter what I do; Excel refuses to group. Tried everything: the settings in options to allow/disallow automatic grouping, going trough all of my cells to make sure they are dates, do the text-to-columns conversion thingy to dates, ... nothing helps. :(
thank you thank you thank you
so we can't do grouping if using power pivot?
Thank you!!!
on the pivot range i have formula, due to which i am not able to group per month and year wise, kindly help to overcome it sir, very often i need to change the data range only then it is working
I got Error every time i refresh the pivot table date are replace with word formula Like formula 01 and grouping is still my problem
Hi, I have a problem in pivot table date grouping.
Before the date grouping in the pivot table, the date is a number e.g. 44186 (12/21/2020). However, when I dragged it to the pivot table, and then to group it into year, quarter, month and date. The date format is changed from a number to a text “Dec-21”. I have no idea why it is changed to text, and how can I keep it in number unchanged? I hope I make myself clear and you understand what my problem is. Thanks.
Nice video, thanks! you cover everything there, though... and you mightfind this one interesting... I have the case where dates are correctly recognised as such in the source data, with proper format,but get screwed up in the pivot table. I am thinking that might be linked to the fact that I have excel set for US formatting and need to enter dates values as M/D/Y but I formated the dates in the source data to be shown as DD-MM-YY (way more logical it feels). Any ideas or tips you may have there? struggling for quite some time on this now... THANKS!
is it possible to put dates in value field of pivot table
Not sure why but I can not group, nothing happens the dates stay the same for some reason.....???? help
God bless you😅
AWSOME YOU ARE MAN
❤️❤️❤️❤️
Not what I needed at all. TH-cam algorithm fails again
Misatkes?
Any vids on caveman pivot tables?
T
Right is correct, left is wrong. Nothing political here😂
Could you maybe leave out the pretentious attitude and focus on the learning?
So long