Pivot Table Grouping | How to Group in Pivot Table in Hindi

Поделиться
HTML-код
  • Опубликовано: 18 окт 2024
  • As you know that Excel PivotTables help you group and summarize your data quickly and very easily. Learn about how to group date with PivotTables.
    1. Pivot Table Date Group Month Wise
    2. Pivot Table Group Quarterwise
    3. Pivot Table Yearwise grouping
    Download the Assignment Master Practice Folder here (All Playlist Example at one place)
    drive.google.c...
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantofficial
    Facebook ► / innozant
    Twitter ► / innozant
    Linkedin ► / inno. .
    #pivottable #pivottablegrouping #Innozant #excelpivot #exceltips #Exceltutorial

Комментарии • 185

  • @vivekkalshan3589
    @vivekkalshan3589 2 года назад +5

    You are the best teacher of my excel thanku very much sir

  • @shilendrakumar5132
    @shilendrakumar5132 2 года назад +4

    Your smiling face is always keep us happy.. love u sir

  • @RohitKumar-cc7zi
    @RohitKumar-cc7zi 3 года назад +7

    Dear sir you have very clear and Crystasl Concept thanks a lot once again, just kerp it up

  • @qamarhashmi3478
    @qamarhashmi3478 7 месяцев назад +1

    Wah Sir, Khush raho, kya khoobsoorat tareeqey sy samjhatey hn. Zinda Bad. God bless you Sir. Allah Hafiz.

  • @Suraj-to6gb
    @Suraj-to6gb 2 года назад +6

    You are the master of Excel ,
    You are the Arjuna of Excel ❤️

    • @Innozant
      @Innozant  2 года назад +1

      ❤️❤️😊 Thanks Suraj.Gid bless you Happy learning ❤️

  • @Mridul-d2z
    @Mridul-d2z 7 месяцев назад +1

    best teacher award goes to uu sirrrrr

  • @devokedevtech2750
    @devokedevtech2750 4 года назад +2

    Aapne mere sabhi consept clear kar diye sir thanks

    • @Innozant
      @Innozant  4 года назад

      Thanks Dheeraj ji appreciate karne ke liye mere mehnat ko.

  • @pradeepnegi7523
    @pradeepnegi7523 Год назад

    Sir aap ki roz main ek video dekti hoon, jis se ab kaam karne main maja aata hain. You are great sir.

  • @nagurshaik830
    @nagurshaik830 3 года назад +1

    superb bhai i cant understand hindi but i received content of the grouping pivot . thank you .excellant class

    • @Innozant
      @Innozant  3 года назад

      Thanks Nagur.Happy learning 🙏❤️

  • @harshsangal6085
    @harshsangal6085 8 месяцев назад

    Appreciate your dedication toward work

  • @awaranyc1
    @awaranyc1 3 года назад

    Tussi Cha gye Paaji... absolutely insane

    • @Innozant
      @Innozant  3 года назад

      Thanks ..God bless You

  • @mohammadwasiuddin6579
    @mohammadwasiuddin6579 11 месяцев назад

    Really marvellous - Sir, Very Informative and time-saving tricks.- Appreciate the way you teach. -thanks

  • @KishankPrajapat
    @KishankPrajapat Год назад

    You are a great teacher, and got avery sweet voice👌👌

    • @Innozant
      @Innozant  Год назад

      Really means a lot to me dear Kishan

  • @asmrindia
    @asmrindia 11 месяцев назад +1

    Nice and Thanks Sir 😊

  • @शिव-ठ6प
    @शिव-ठ6प Год назад

    झा जी बहुत नीक ज्ञानवर्धक प्रस्तुति।

    • @Innozant
      @Innozant  Год назад

      Hahaha..Thanks dear .😊

  • @rinturoy8014
    @rinturoy8014 11 месяцев назад

    I thought I would know a lot about pivot tables. I was not aware of many unaddressed topics related to pivot tables. However, I chanced upon this channel.

    • @Innozant
      @Innozant  11 месяцев назад

      Thanks Dear.Keep learning

  • @MarathwadaDoors
    @MarathwadaDoors Год назад

    Thankyou very much sir you are doing a great job thank you very very very much once again.

  • @narayandaskarwa1700
    @narayandaskarwa1700 Год назад

    I like the explanation part..nicely explained

  • @harshsingh3401
    @harshsingh3401 Год назад

    you rock sir I so much disappointed from excel but after watching your videos I once again motivated to learn excel 😊😊😊

  • @ranjannayak99
    @ranjannayak99 Год назад +1

    You are doing an amazing job selflessly...I salute your efforts and dedications towards it...Keep it up...

    • @Innozant
      @Innozant  Год назад

      Thanks Rajan.. Really means a lot to me dea..Happy learning 👍❤️

  • @gavidiharish13
    @gavidiharish13 Год назад

    Recently got an offer as Reporting Analyst, your videos helped me a lot thank you sir

    • @Innozant
      @Innozant  Год назад +1

      Congratulations..Have a wonderful career ahead

    • @gavidiharish13
      @gavidiharish13 Год назад

      @@Innozant Thank you so much sir

  • @shaileshkumar-qf6bd
    @shaileshkumar-qf6bd 2 года назад

    Shukriya sir extra knowledge ke liye😊

  • @sushilshukla7296
    @sushilshukla7296 3 года назад +1

    I watch all video thanks sir

    • @Innozant
      @Innozant  3 года назад

      Thanks..Watch and learn step by step ..all playlist m👍♥️🙏

  • @sawaimalhi8439
    @sawaimalhi8439 3 года назад

    kiya baat hai sir first time ye concept suna hai main classic pivot ka kiyn k kabi b muje udemy k teacher say nhe mila ye concept

    • @Innozant
      @Innozant  3 года назад

      Thanks Sawai..Happy Learning

  • @tayyabraza4303
    @tayyabraza4303 3 дня назад

    really helpful

  • @jyotichaudhary7231
    @jyotichaudhary7231 4 года назад

    Very appreciable,voice, presentation skill nd deep insight of Excel sheet,I will see nd learn more from your other videos...Thnku sir 😊😊👍

  • @yashpatil3375
    @yashpatil3375 8 месяцев назад

    Exllent sir ji

  • @riyadalela6096
    @riyadalela6096 4 года назад

    Very nice video sir..

  • @dilipshedge8503
    @dilipshedge8503 2 года назад

    Very nice ✔️

  • @dhakafady774
    @dhakafady774 Год назад

    thanks a lot sir

  • @dhakafady774
    @dhakafady774 Год назад

    sir you are awsome

  • @sameenarafiq1339
    @sameenarafiq1339 3 года назад

    Great... Thank you so much sir

    • @Innozant
      @Innozant  3 года назад

      Thanks Sameena.. Recommend you to start your learning journey in sequence
      From Basic Excel onwars then sorting,filter,adv filter,subtotal ttc,Data Validation ,Array & Sumproduct ,Lookup series ,Chart ,Pivot table followed with dashboard.
      In sequence playlist are available in video description
      Master assignment excel exetcise are already there for your practice. ❤️🙏

  • @aakritibhatnagar1991
    @aakritibhatnagar1991 3 года назад

    Very well explained sir👍

    • @Innozant
      @Innozant  3 года назад

      Thanks Aakriti,Hope you learn from there.Happy learning..Good Night.tc

  • @kumarsamir1929
    @kumarsamir1929 2 года назад

    Thank you sir 😊😊😊

  • @kinghundred
    @kinghundred 3 года назад

    very nice sir

  • @hamzazayd3463
    @hamzazayd3463 3 года назад +1

    Excellent

  • @sachingurung1974
    @sachingurung1974 Год назад

    God of execl❤

  • @bhaktivedios-g9t
    @bhaktivedios-g9t 2 года назад

    Awesome sir.

    • @Innozant
      @Innozant  2 года назад

      Thanks dear❤️

  • @md-gl6eh
    @md-gl6eh 2 года назад

    Thank you so much

  • @sandeeplade4949
    @sandeeplade4949 3 года назад +1

    Sir, Very Informative and time-saving tricks.
    Request to share tutorial video for grouping with 15 days and weekly basis. it will help in understanding sales value lower, higher for particular weeks of months.

  • @monalisa_ghosh1
    @monalisa_ghosh1 Год назад

    Great teacher ❤️

    • @Innozant
      @Innozant  Год назад

      Thanks Monalisha.. Really means a lot to me

  • @forgotten_friend5406
    @forgotten_friend5406 2 года назад

    nice teaching

  • @Ann_2208
    @Ann_2208 2 года назад

    Fantastic sir

  • @mohammadwasiuddin6579
    @mohammadwasiuddin6579 11 месяцев назад

    superb

  • @yogeshpimple2860
    @yogeshpimple2860 Год назад

    Superb

  • @bhoopendraraghav9781
    @bhoopendraraghav9781 4 года назад

    Excellent sir g

    • @Innozant
      @Innozant  4 года назад +1

      Thanks Bhoopendra,Keep watching and enhance your skills

  • @dipakkumarpradhan294
    @dipakkumarpradhan294 2 года назад

    Amazing

  • @dancertrishika
    @dancertrishika 3 года назад

    Superb sir and thank you 🙏

    • @Innozant
      @Innozant  3 года назад

      Thanks Bhaskar ji

  • @surajitmaji1348
    @surajitmaji1348 Месяц назад

    Best...

  • @msexcelgooglesheet374
    @msexcelgooglesheet374 4 года назад

    good video.

  • @pawanverma7220
    @pawanverma7220 3 года назад

    Itna Deeply Kisi Ne Kabhi Nahi Bataya Pivot Table Ko,
    Pivot Table Mai Sabhi Raw Data Ke Base Par MIS Create Karke Batate Hain, Lekin Aap Pivot Table Use Kaise ki jaati hai wo sikhate hain.
    💞💞💞

    • @Innozant
      @Innozant  3 года назад +1

      Thanks Pawan ji...Kyunki main aplpgon ko complete course Kara raja hu na ki views badhane ke liye sports videos ya tricks videos banana hai😀Halpy learning..seekhiye aur life me age badhiye

  • @bhuvankumar6430
    @bhuvankumar6430 3 года назад

    Great 👍

    • @Innozant
      @Innozant  3 года назад

      Thanks 🙏❤️

  • @huzaifakanakgeri7142
    @huzaifakanakgeri7142 2 года назад

    Hats off sir

  • @abhishekchaturvedi1788
    @abhishekchaturvedi1788 3 года назад +1

    What version was the monthly & week & group pivot table video in.
    I liked the video very much but I have got a lot tp learn for us
    Give you mobile number
    Explaining pivot table in more detail
    Because I am preparing for job from this video channel
    Also tell about how the data should be

  • @rayyanracks9477
    @rayyanracks9477 3 года назад

    very nice

  • @hemgandhi8087
    @hemgandhi8087 2 года назад

    Thankx

  • @vijaysahal4556
    @vijaysahal4556 3 года назад

    Nice sir 👍🏻👍🏻👍🏻👍🏻

    • @Innozant
      @Innozant  3 года назад

      Thanks Vijay Ji

    • @vijaysahal4556
      @vijaysahal4556 3 года назад

      @@Innozant hi sir I have some query I cnt solve it so plz hlp me
      I have some small data set nd also allready result there but I cnt understand
      Topic here is how cn share my data set wid you I hve no your whatsup

  • @trilokijha5223
    @trilokijha5223 3 года назад

    Dear sir
    We can apply classical layout or do same in google sheet. Pls let us to know.

    • @Innozant
      @Innozant  3 года назад +1

      Jha ji soon you may able to leanr comple Google sheet

  • @AkshayKumar-ko2ny
    @AkshayKumar-ko2ny Год назад

    Can you please make us understand "how to make the data in week wise"..??

  • @pawanverma7220
    @pawanverma7220 3 года назад

    Operation Of Pivot Table 🔥🔥🔥

  • @nishikant2354
    @nishikant2354 2 года назад

    Sir how to insert row and column in existing pivot table? Plz guide me sir with example

  • @KRISHNATAWARFROMINDIA
    @KRISHNATAWARFROMINDIA 3 месяца назад

    SIR YOUR EVERY VIDEO USEFUL FOR ME BUT I AM A FACEING ONE ISSUE I SHOW OUR COMPLETE TASK ANY TOPIC IN BELOW OF DISCRIPTION AND I DOWNLOAD FILE FOR WORKING PURPOSE BUT I CAN NOT SEE ANY APPLICABLE FARMULA IN FRONT OF ANY TAXT SO PLEASE SHOW THIS FARMULA SO THAT I AM WORKING PROPERLY AND LEARNING PROPER ADVANCE EXCEL THANK YOU SIR FOR YOUR SUPPORT .

  • @md.taifuranam7904
    @md.taifuranam7904 2 года назад +1

    Thanks a lot dear Tainer. I am from Bangladesh. Newly subscribed your channel. Really your teaching I am enjoing and learning more.
    I have question, hope will get answer. Can It is possible to mearge advance table cell?

    • @Innozant
      @Innozant  2 года назад

      Yes we can merge tables using PQ method

  • @shrikantbadge3978
    @shrikantbadge3978 9 месяцев назад

    East or west Innozant is best

  • @gauravbhatia7987
    @gauravbhatia7987 3 года назад

    Good

  • @AbdulAzizBaloch
    @AbdulAzizBaloch Год назад

    Nice

  • @RamSingh-ol5xz
    @RamSingh-ol5xz 4 года назад

    Nice 👌

    • @Innozant
      @Innozant  4 года назад

      Thanks Ram,Bade dino baad?Kahan the

  • @sachingurung1974
    @sachingurung1974 Год назад

    Where is your coaching centre sir

  • @mohammadkhan596
    @mohammadkhan596 3 года назад

    Please tell me sir it needs any tool for create pivot table group like weekly, monthly ,yearly.

    • @Innozant
      @Innozant  3 года назад

      No dear ,pivot table is used to group the data as per your requirement

  • @saidulislamkhan4278
    @saidulislamkhan4278 3 года назад

    Dear, show us how to make % of Target vs Achievement. Thanks

  • @hukamverma9277
    @hukamverma9277 3 года назад

    Thanks

  • @ajitmali855
    @ajitmali855 2 года назад

    Sir how to grouping financial year month wise
    ie April to March

  • @naryacreation9404
    @naryacreation9404 2 года назад

    Error showing in my excel as "cannot group that selection" please help
    My formatting of date is correct mm-dd-yyyy

  • @umeshchandarana8415
    @umeshchandarana8415 3 года назад

    Wah . Maja Aa gaya. But Sir still work on volume please.

    • @Innozant
      @Innozant  3 года назад

      Thanks..Volume is fine now..you may check in latest videos

  • @pawanwakale8801
    @pawanwakale8801 2 года назад +1

    Sir , second example me jab group karte hai right click karke tab "cannot group that section" message reflect hota ,

  • @minakshisharma7744
    @minakshisharma7744 2 года назад

    Osm

    • @Innozant
      @Innozant  2 года назад

      Thanks Sharma Ji .Happy Learning ❤️

  • @MuhammadImran-mb9my
    @MuhammadImran-mb9my Год назад

    i am usuing excel 2013 but grouping is not working...unable to use this trick

  • @pramodbhatt6906
    @pramodbhatt6906 2 года назад

    Hello Sir, I want my Qtr1 starts from April. What to do?? Pl help

  • @hemantrawat1063
    @hemantrawat1063 2 года назад

    date format are correct but date group but showing cannot group that selection ...plz help ..

  • @shivkumarshakya2280
    @shivkumarshakya2280 2 года назад

    👌👌❤

  • @prithvisahay269
    @prithvisahay269 2 года назад

    Sir, pivot me har name ke numbers ke baad total aa raha hai kaise remove hoga..please bataye

  • @vishalbhati912
    @vishalbhati912 3 года назад

    Sir mera sawal tha ki. Humara financial year jo Hota he april se start hokar march par khatam hota he. Par hum jab pivot banate he. Toh wo jan uppar or dec. Last me batata he. Jabki humara jo dec. He 2020 ka he or jan 2021 ka. Toh hum kese use april se march show kare. Plz tell me.

    • @Innozant
      @Innozant  3 года назад

      Add extra column using in pivot using set value

    • @vishalbhati912
      @vishalbhati912 3 года назад

      @@Innozant sir aap plzzz koi video banake samjhayenge ispe. Q ki ye office work k liye bahot useful he.

  • @MathsTutorSubrata
    @MathsTutorSubrata 3 месяца назад

    Please help, I need weekly data.
    How can I do this

  • @chayarawat7637
    @chayarawat7637 3 месяца назад

    Sir group nhi ho rha ha they are showing.cannot group that selection what to do now

  • @pawanwakale8801
    @pawanwakale8801 2 года назад

    Sir hum date par hi grouping kar rahe toh error aa raha cannot Group that section., jab tak yeh solve nhi hoga hum aage nhi jayenge ,kyoki ki humne jab age k video dekha toh usme bhi yehi error aa raha tha

    • @Innozant
      @Innozant  2 года назад

      Data format check kijiye..wrong date format hoga to erro aayega..proper date format hoga tabhi to date group hoga dear

  • @manojharbola7936
    @manojharbola7936 3 года назад

    Sir formula kesa lgate hai

    • @Innozant
      @Innozant  3 года назад

      Wo to situation par depend krta ha apki kya requirement hain

  • @pashupatijha7719
    @pashupatijha7719 3 года назад

    sir, how to do grouping in week wise?

    • @Innozant
      @Innozant  3 года назад

      Jha ji already karaya hua hai grouping..pivot table series dekhen.. grouping ..

  • @tarun_k_shorts
    @tarun_k_shorts 3 года назад

    Sr pivot table copy paste keise krte h uski shortcut plz btae

    • @Innozant
      @Innozant  3 года назад +1

      Jaise normal paste krte hain .ya paste special..Ctrl alt v

    • @tarun_k_shorts
      @tarun_k_shorts 3 года назад

      @@Innozant kisi Kuch particular customer ka data pivot table me se copy krke another sheet me paste krte h to different ata hai (apne kisi ko comment me btaya bhi tha paste special se or sort cut se both bta dejiye}

    • @tarun_k_shorts
      @tarun_k_shorts 3 года назад

      @@Innozant paste special

  • @Balwan_Singh
    @Balwan_Singh 2 года назад

    Same source data se 2 pivots ko alag alag kaise group karen? Ek ko ungrpoup karne se dusra ungroup nahi hona chahiye.

    • @Innozant
      @Innozant  2 года назад +1

      Kisi video me explain kar denge Balwan ji

  • @battlefansshorts8941
    @battlefansshorts8941 3 года назад

    🙏🙏🙏🙏

  • @shwetkumar1719
    @shwetkumar1719 3 года назад

    Sir to hmm classic ka use kb krege

    • @Innozant
      @Innozant  3 года назад +1

      Apki requirement ke upar depend krta h

  • @advocatepankajsaini8934
    @advocatepankajsaini8934 3 года назад

    Sir mujay outstanding report bannni hai for example 31 August tak mari outstanding thi 1000000 or September may billing hue 1lakh or September may recovery hue 8 lakh toh y kasy manage kary jissy balane outstanding amount show ho

    • @Innozant
      @Innozant  3 года назад

      Mujhse kya help chahte hain detail me explain kijiye ek baar

  • @SURINDERKUMAR-v3s
    @SURINDERKUMAR-v3s 7 месяцев назад

    Sir mere laptop me grouping function not working what i do now

  • @lkumar2727
    @lkumar2727 4 года назад

    sir yeh toh hame bhi aata h but mujhe Quarter ( Apr to mar chaiye) na ki jan to dec toh wiase kaise hoga sir

    • @Innozant
      @Innozant  4 года назад

      Month function pass krke phle month ka custom list bna lonjis month se jis month tak chaiye phir uske base par pivot table..

    • @lkumar2727
      @lkumar2727 4 года назад

      @@Innozant Thanks Sir,,,, you r great🥰

    • @Innozant
      @Innozant  4 года назад

      @@lkumar2727 Thanks dear

  • @shwetkumar1719
    @shwetkumar1719 3 года назад

    Matlab agar layout ko hatana hai to?

  • @aditiverma1573
    @aditiverma1573 Год назад

    Sometime field list show nhi hoti what is the short cut key ?

    • @Innozant
      @Innozant  Год назад

      Click on pivot table -analize tab-field list is there or Press F6

  • @RajatSharma-h5m
    @RajatSharma-h5m 10 месяцев назад

    option nhi aaye to kya kare. Grouping option nhi aa rha h dropdown mei

    • @Innozant
      @Innozant  10 месяцев назад

      Kyu ?kaunsa version h

  • @ashrafahammad1801
    @ashrafahammad1801 3 года назад

    Y can't do grouping on my excel sheet.

    • @Innozant
      @Innozant  3 года назад

      Are you asking your query or challenging😀

  • @tarun_k_shorts
    @tarun_k_shorts 3 года назад

    Sr date par right click krne pr grouping nhi a rha can't group likha a rha h

    • @Innozant
      @Innozant  3 года назад +1

      Merged pivot hoga..seprate pivot kisi data par click krke bnaiye jisme dat ya time field ho..aayega group ka option dear

    • @tarun_k_shorts
      @tarun_k_shorts 3 года назад

      @@Innozant thnx

  • @tarjitmalka3978
    @tarjitmalka3978 4 года назад

    ⭐⭐⭐⭐⭐