Sort & Filtering data using Pivot Table on LibreOffice calc
Repository
https://github.com/LibreOffice/core
What Will I Learn?
In the video I give an explanation how to create pivot table.
- You will learn how to using Pivot table.
- You will learn about Pivot table layout.
- You will learn about placing pivot table destinations.
- You will learn how to change display of pivot table.
- You will learn how to filter pivot table data.
What is LibreOffice Pivot table?
A pivot table make it easy rearrange, sort, and filter data in a table without using formulas. this is very useful and makes the data can be used more instantly.
Requirements
- System Requirements : Program Install Support Install and Uninstall
- System Requirements : No special requirements.
- OS Support : Windows (XP, 2003, Vista, 7, 8 and 10) GNU/Linux (x86 and x86-64, RPM and DEB based Linux distributions) Mac OS X (x86-64 only)
Information
- Website & Download : https://www.libreoffice.org/
- Type : Office suite software
- License : MPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[9]
- Operating System : Linux, Windows, macOS,[5] FreeBSD, OpenBSD,[6] NetBSD, Android (Viewer)
- Platform : IA-32, x86-64, ARMel, ARMhf, MIPS, MIPSel, PowerPC, Sparc, S390, S390x, IA-64 (additional Debian platforms)[7]
Difficulty
Intermediate
Description
Pivot table is a unique function that makes users more easily get more instant data results. pivot table does not use a formula to determine the result, you can use pivot table to rearrange, sort, filter data very quickly and easily.
In the photo above, at the time of making pivot table, there are many functions such as Data Field, data field give some function like, Sum, Count, Average, Median, Max, Min, Product, StDev, StDevP, Var, VarP which have same function as formula.
In the photo above, the Pivot table can sort the data to be displayed by simply checking and unchecking the options.
In the photo above, sorting data by date can be done simply by checking and unchecking options.
In the photo above, adding a filter feature to the pivot table is done when creating a pivot table. filter provides a choice of criteria to determine the data to be filtered, the criteria filter has 2 operators namely AND & OR function. so you can determine the filter results you need more accurately.
In the photo above, while filtering the data, you can also specify the data condition with some condition options, such as = , < , > , <= , >= , <> . and determine the value that makes the results more accurate.
Video Tutorial
Proof of Work: Pivot Table Sort & Filtering data
You can download my pivot table sort & filtering data files
very very good content , i just read your content its have good nformation for us thanks for sharing :) @darsondrew
Thank you for your support :) @khushbakht
you are always welcome :)
Hi @darsondrew
Thank you for your contribution and here are some areas that you need to make improvement on.
In a video tutorial, the teaching element is very important to explain concepts and insights into the function.
Just showing on screen what you do is not enough for a tutorial. The learner needs to know the principles behind the working of the function so that they can apply it to their own situation.
Your video tutorial needs to supercede the tutorials that are already seen on you-tube and elsewhere. You need to give teaching on the functionalities of the techniques.
Your contribution has been evaluated according to Utopian rules and guidelines, as well as a predefined set of questions pertaining to the category.
To view those questions and the relevant answers related to your post,Click here
Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]
Hey @darsondrew
Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!
Contributing on Utopian
Learn how to contribute on our website or by watching this tutorial on Youtube.
Want to chat? Join us on Discord https://discord.gg/h52nFrV.
Vote for Utopian Witness!