https://github.com/LibreOffice/core
In the video I give an explanation how to create 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.
Intermediate
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.
You can download my pivot table sort & filtering data files
