Get Quarterly Totals in Excel with this AWESOME Trick 💡

[@phanthibaovien]

At 1:40 I wondered what’s more for another 2 mins, turn out the relationship is magic. I love it. Thank you Chandoo!

[@chandoo_]

You know me... I like to spoil our viewers 😀

[@Mamtha7272]

Chandoo Anna, Your way of teaching I really liked it. Thank You for helping us.

[@wayneedmondson1065]

Thanks Chandoo! A great quick Pivot Table exercise to illustrate how to solve a common reporting requirement. Thanks also for providing the sample file to follow along.. much appreciated! Thumbs up!!

[@chandoo_]

You are welcome Wayne... :)

[@Seftehandle]

advice to add a superthanks button :) i really enjoyed data relationships & pivot from data model. simply explained -so its easy to follow through, yet so powerful! plus , i bet it saves space in excel. the editing is beautiful

[@chandoo_]

Thanks Tina. Your lovely comments mean so much more than the Superthanks. :) The Superthanks feature is not enabled for my channel. May be it will be added in coming months.

[@vijayarjunwadkar]

Thank you Chandoo for yet another useful video! Liked the financial year quarter tip especially! 😊👍

[@chandoo_]

Glad it was helpful!

[@real5731]

Crisp and clear

[@chandoo_]

Thank you :)

[@kishorka2559]

Hi Chandoo, How to identify the which pivot table is overlapping?? With and without VBA

[@chrism9037]

Great video Chandoo, thanks!

[@LisaPratt-d6j]

Very helpful. Thank-you.

[@moesadr3342]

Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?

[@36chethan]

Great... I just got an idea that instead of creating calendar tabe we can add one more coloum and select our quarters start and end date manually enter the respective quater name and use it in pivot tabe... Thanks i learner that we can interconnect two different tabe which i believe we can do it on power query only...

[@latiefmakhdoomi]

Hello thank you for your tutorials. Suppose I have to invest certain sum of amount SIP and increase the amount quaterly, how I can auto calculate the amount that I will be investing for the year in excel?

[@MrAloha]

Chandoo Rocks!! 💪😁🌴🤙

[@manishchoudhary1871]

Sir, Can we find some keywords in bank account statement together or we'll have to search for individual keyword? If it can be done, please make a video.

[@ysantosh]

Chandoo anna. Nice video & explanation. Thank you 😊

[@chandoo_]

Thank you so much 🙂

[@rahulpaul5978]

hi, how can one get quarters on data model or the calendar table

[@gonshugaming8624]

sir can you make portofolio crypto in excel ? with live price thanks

[@143lexus]

How did you get rid of the grid lines?

[@hamzasaeed2741]

Data source bhi sir provide kr dia kren

[@massoud991]

Hi Master Is it possible to use different datasets in the analysis because all the tutorials are about purchasing sales datasets?tnx

[@chandoo_]

Thanks for the suggestion Diamond. While the dataset may refer to "sales" techniques can be applied to any dataset. I will test out a few different variations on my upcoming videos.

[@massoud991]

@@chandoo_ you're great man

[@ImmanuelChale]

Hi Chandoo, greetings from a new subscriber. Would be possible to set financial quarters by intervals instead of the calendar table? I mean, instead of a long table with all the dates just four intervals?

[@chandoo_]

You need calendar table (and most organizations maintain one in a database / warehouse). If you have start ranges, you can generate the calendar table with Power Query and use it in your reports.

[@taizoondean689]

Thanks

[@missadventure7564]

Hi, I have a date column and trying to put as month and year in pivot table - But my excel version wont do that. any suggestions? Thanks

[@chandoo_]

Which version of Excel are you using? The right click "Group" option is available since Excel 2007. If you have already added your data to the "data model", then you must use a calendar table to group as the "grouping" feature for dates is not available with data model pivots.

[@cpalaniraj8196]

For Indian financial calender from April to March how to arrange pl confirm

[@chandoo_]

I show the same in the video. Please watch the whole thing.

[@yashwanthreddy7533]

hyyy power bi as future like job trend i am from india

[@matthewv4170]

I use a month() switch formula for this

[@chandoo_]

That is a good one :)

[@775shahrukh]

plzzz....dashboard plz

[@wilmarkjohnatty4924]

Its is extremely clumsy, esp the second part. And is there a reason you only choose ONE year? You end up with Summary By year which you dont want if you are going to do any kind of data analysis, and if you remove the years - everthing is summarized by Q1 etc (that is all Q1's are combined).

[@nakulgupta142]

your pace of delivery is too much...beginner level person like me struggle to keep pace and do steps one by one..

[@lakshmidevicollections1333]

I msg in mail sir once check