Pinned this comment to note that my comment in the video at 06:00 is not accurate. It's not necessarily true that applying custom functions to headers will result in an error. I suspect the error here is due to applying the YEAR function to the word "OrderDate" (the header of the OrderDate column in vSales). As correctly pointed out by Ismail, this returns the word "OrderDate" in the first column header: =GROUPBY(HSTACK(VSTACK(vSales[[#Headers],[OrderDate]],YEAR(vSales[OrderDate])),vSales[[#All],[Category]:[SubCategory]]),vSales[[#All],[SalesAmount]],HSTACK(SUM,MAX),3)
I wouldn't go that far just yet 😂 Certainly it will mean lots of people will stop using Pivot Tables in favor of the functions, but I doubt Pivot Tables would ever be removed entirely.
What if you use VSTACK(YearColHeader,YEAR(YearColDatabody)) for the first argument on that? I don't have Groupby yet so i can't test it out.
Yes I think you're right. That's what Diarmuid suggested as well.
Pinned this comment to note that my comment in the video at 06:00 is not accurate. It's not necessarily true that applying custom functions to headers will result in an error. I suspect the error here is due to applying the YEAR function to the word "OrderDate" (the header of the OrderDate column in vSales).
As correctly pointed out by Ismail, this returns the word "OrderDate" in the first column header:
=GROUPBY(HSTACK(VSTACK(vSales[[#Headers],[OrderDate]],YEAR(vSales[OrderDate])),vSales[[#All],[Category]:[SubCategory]]),vSales[[#All],[SalesAmount]],HSTACK(SUM,MAX),3)
Spectacular. The definitive end of pivot tables. Thank you!!!
I wouldn't go that far just yet 😂
Certainly it will mean lots of people will stop using Pivot Tables in favor of the functions, but I doubt Pivot Tables would ever be removed entirely.
Great Tutorial 👏 So many Insights in just 9mins 🙌
Thank you, Bhavya 🙏
Absolutely blown away by the content of this video. This video will standout in videos on Excel. Thank you sir 🙏
Thanks for your support! I appreciate it 🙏
Awesome as always. Thanks for sharing, Owen!
Cheers! 👍
Loved it!
Good stuff Owen
Cheers! 👍
Absolutely Amazing. Thanks!!!
Glad you liked it!
Thanks for sharing!
I wish the excel formula bar of yours in the video could be more clear or zoomed...
Will try to make it better next time. Thanks 👍
Perfect 👍 please share data file for practice
Awesome video 👍
Thanks! 🙏
Thanks! 🙏
thanks
Is it available already?
This is currently only available on the Insiders Beta channel.
How can I use in office 2016