August 15<sup>th</sup>, 2021 

<div class="text-justify"> 

<center><h2>LibreOffice Pivot Table</h2></center>

I have been using and learning about LibreOffice for a few years now, and thought I would share a useful tool I only recently learned about. Last year @paulag did a post and video on Pivot tables in Excel, but I never took the time to fully check out pivot tables in LibreOffice, it just looked to complicated, and well at the time I was not tracking so much information. I should have they are a great and simple tool.

So here is a simple walk through for examining Data via LibreOffice Calc. I am tracking a few different tokens that I hold, and the spreadsheet is getting rather lengthy and I needed a way to see a quick view of different totals. Below is a shortened image of my BRO token transactions:

<a href="https://files.peakd.com/file/peakd-hive/bashadow/23tSuuMCJYKuqUvGne8B899Cyuo9QNvhLF6CC1RARr4t1giaEiE9LCZZYuGCHr4qvhZcf.png"><img src=https://files.peakd.com/file/peakd-hive/bashadow/23t88ew2UJz6Xv3RSpbWrwUPiEdGaHo4DjqcdMvLLbSM5RALERoHoc8LdJ3QCixphdseG.png></a><center>Clicking the above image will give you the full list</center>

That's a lot of numbers and it has gotten to the unwieldy level for me.

First step is to open your spreadsheet of course:

![highlight and pivot table.png](https://files.peakd.com/file/peakd-hive/bashadow/EoH3oAoAtbTGbmuSCsvLGFBf3ydadqTHevUKs7taDuxWRu27XKEqt1uAGgo2Lxn9Xx5.png)
Select the information you want to evaluate then under **Insert** tab click Pivot Table.

<hr>

![highlight and pivot table 2.png](https://files.peakd.com/file/peakd-hive/bashadow/23wCX5AFVeDz6ZT3FLrHeGBwEojvdSVSbmLCzvZabRtnuW1Q16JXooGrvnQUSu1k39nkK.png)

You get a small option box if *Current Selection* is not clicked, click it and then click OK.

<hr>

![highlight and pivot table 3.png](https://files.peakd.com/file/peakd-hive/bashadow/EoKB6hMyn1agPoWD8wWV6z4W6tv6kKiq3Sg2UTeF77AGAgpCy5tTe86n8aCZsM8pVWV.png)
Here is where things got a little tricky for me. After about 5 tries I got it to do what I wanted. Filters is basically - what do you want to see. I wanted to know how many tokens I owned. To get to that number I need to know how much *Market transfer*, and *Market Buy*, and of course I did not start tracking early enough so I need to know what my *correction* factor was.

You simply grab the fields you need from the right hand box and drag them to where they need to go. For this operation we needed the *Operations* Field and the *Amount* field.

<hr>

![highlight and pivot table 4.png](https://files.peakd.com/file/peakd-hive/bashadow/23uFphEF7yYCHtN97xf7ZxcDx9q9PAruYRV9nZbwQ6fXqLc34ohYzkLVVpUrugycFXBgA.png)

So since the above information is in the **Operations** column that got dragged over to the **Row Fields** box also. Of course since I wanted to know the amounts *Amounts* got placed in the **Data Fields** box.

<hr>

When you click OK this is the view you will get:
<center>![results 1.png](https://files.peakd.com/file/peakd-hive/bashadow/23tw66Yrm5PksUFFfgD2SqcyFzrQ2gZS8tFdGtaTvF6kVTbR7gvV36AB4GmP5rnkt1tG4.png)</center>
All the different operations in the column are shown and their individual totals. (one thing I have yet to figure out is how to keep the larger font, I have to highlight and manually change it every time).

<hr>

Now I want to know how many tokens I own:

<center>![results 2.png](https://files.peakd.com/file/peakd-hive/bashadow/23tmj5emX7MhMNgUYDo5Tbf7cpUwKhU7d2vBw66uq21eKh81ZUFnuAqFjZuqx6g913w22.png)</center>
Simply click on the operations down arrow and you get the option to choose what data you want to view.

<hr>

<center>![results 3.png](https://files.peakd.com/file/peakd-hive/bashadow/23tw5ZEZMF1TYJCA8Mq5iq7CdGeHw96acJfEoSQd2QSyM2nJPDKrmUAvtpqCPkK8Scm88.png)</center>
I wanted to know how many I owned so I deselect *market_placeOrder* and *market_sell*

<hr>

The results:

![results 4.png](https://files.peakd.com/file/peakd-hive/bashadow/23tcJrEf5urXGUp3Eynhaup6CzXM8kUCE2hPYQxR6UGzr8sZ4v54XFpAWNH114cdXwcwj.png)

<hr>

There are a lot of ways to view and manipulate large amounts of data, I am by-far not the most technical person or spreadsheet user, but the user guide was sufficient for me to figure out how to use the Pivot table function with out having to find help via Youtube or google.
 


<center><sub>Tiny Picture links back to my blog:</sub></center><center><a href="https://peakd.com/@bashadow"><img src=https://images.hive.blog/100x50/https://files.peakd.com/file/peakd-hive/bashadow/CSiw0Xl5-avatar3.png></a></center>

</div>