Pivot Table - Libre Office Calc Tutorial

Поделиться
HTML-код
  • Опубликовано: 5 дек 2024

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

  • @daverage4729
    @daverage4729 4 года назад +7

    Fantastic guide sir! Certainly beats the horrible Calc instruction manual. Thanks again for taking the time to do this.

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

      Cool 😎 thanks 👍

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

      Would be awesome if you can give me a Google review 👍
      g.page/dcpweb/review?gm

  • @danieldaanna
    @danieldaanna 6 лет назад +4

    I didn't know how to do this. Thank you! Your tutorial is very easy!

  • @dhruv043
    @dhruv043 3 года назад +2

    Fabulous.. Thank you very much..
    I was wondering about this since morning.. Your video helped me a lot.
    Keep up the good work.

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

      Thanks 👍

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

      Would be awesome if you can give me a Google review to help my business 👍
      g.page/dcpweb/review?gm

  • @anthonyheak3479
    @anthonyheak3479 4 месяца назад +1

    Very good explanation, thank you! Learn some new today.

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

    This is really helpful. Thank you for providing this tutorial. Your explanation is really good.

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

    Great tutorial Sir! Grateful for teaching me.

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

      Thanks 👍

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

      Would be awesome if you can give me a Google review 👍
      g.page/dcpweb/review?gm

  • @h7opolo
    @h7opolo 2 года назад +2

    9:15 ah, nice trick i could use

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

      Great 👍

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

      Would be awesome if you can give me a Google review 👍
      g.page/dcpweb/review?gm

  • @60sTango
    @60sTango 6 лет назад +2

    Saved a huge time for me.

  • @rifaeeehaimed3635
    @rifaeeehaimed3635 7 месяцев назад

    I have Liber Office on Mac. I couldn't delete Date from the pivot table
    Also, I need to get different colors for the results
    Thanks so much

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

    Ok, question: If one big pivot table is created (as in 9:10) and you select from it data for chart, and generate that chart, then if you change sorting or data range from dropdown menu of this pivot table, what will happen with chart?

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

      Good question, answer not sure, but if you want the chart to be static then copy the data to a new sheet then make the tables I will do a test when I get some free time as well..

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

      @@dcpwebdesigners Thanks, appreciate.

  • @bluemaxcnc4749
    @bluemaxcnc4749 5 лет назад +2

    Thank You that was a great tutorial!

  • @davidgarcan
    @davidgarcan 5 лет назад +1

    Very useful tutorial! Thanks

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

    Thank you so much!

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

    Hi, Can you let me know, How to apply Pivot table through Macro in the Libre office?

  • @meanmeanpt
    @meanmeanpt 6 лет назад +2

    Hi, looked for the spreadsheet data and can't find it neither here neither on the dcpweb page of this tutorial. Could you provide the corresponding link?

    • @dcpwebdesigners
      @dcpwebdesigners  6 лет назад

      Hi, I have uploaded spreadsheet here: www.dcpweb.co.uk/blog/libre-office-pivot-table-tutorial

    • @meanmeanpt
      @meanmeanpt 6 лет назад +1

      Awesome! Many thanks.

  • @brentsandiwiebe7471
    @brentsandiwiebe7471 6 лет назад +1

    Thank you. Very helpful.

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

    This is an awesome tutorial. Thank you very much. But what is "Data" in the Column Fields here at @8:50 ? Thank you very much.

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

      Thanks, data is the columns or content selected in the spreadsheet

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

      @@dcpwebdesigners Yeah but in the other pivot tables, you deleted that "Data" and didn't use it. I'm confused.

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

      Honestly I made that tutorial over 4 years ago and I don't remember all the steps, you will need to watch carefully and read a little documentation on libre office

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

      Please check help.libreoffice.org/Calc/Creating_Pivot_Tables

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

    Do you know if it's possible to do calculated fields other than manually doing?
    Thanks for the vids

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

      Sorry not sure, I normally setup formulas manually and then copy as required.
      have fun 👍
      Would be awesome if you can give me a Google review to help my business 👍
      g.page/dcpweb/review?gm

  • @taraknathsam4572
    @taraknathsam4572 5 лет назад

    How to creat calculate filed in pivot tabel in libre calc plz suggest

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

    thank you

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

      Cool 😎 thanks 👍

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

      Also check out my new blog for more free tutorials www.dcpweb.co.uk/blog

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

      Would be awesome if you can give me a Google review 👍
      g.page/dcpweb/review?gm

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

    im trying to format my inventory into a table saying error to much information maybe? or same items over and over again?

  • @gms9810
    @gms9810 7 лет назад +2

    That was helpful, thanks

  • @AslanTamjidi
    @AslanTamjidi 5 лет назад +1

    Useful video... Ty

  • @jayPatel-zu2rc
    @jayPatel-zu2rc 5 лет назад +1

    how can i unhide the column in the libreoffice excel ??

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      Left click in top left corner to select all cells in spreadsheet, right click on any column letter and then select show option

  • @realgamer1998
    @realgamer1998 6 лет назад +2

    very helpful

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

    thanks man :)

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

    👍👌

  • @uttamprakash4309
    @uttamprakash4309 6 лет назад +3

    I use calc because I can't afford Excel.

  • @SmallGuyonTop
    @SmallGuyonTop 5 лет назад

    Why are you SLAMMING the keyboard. It is quite offensive. Back off the keys abuse. It seems to only be on the ENTER key. CALM DOWN!

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      😂

    • @cristinabianes
      @cristinabianes 5 лет назад +1

      how to create a second pivot table in same sheet?

    • @dcpwebdesigners
      @dcpwebdesigners  5 лет назад

      @@cristinabianes I don't think that is possible as the pivot table is used to analyse the data set. You can only the data to a separate tab sheet in the same document and run a different pivot table.