You know sometimes you can really use a Pivot table if you don't know what that is.
I show you right now a pivot table is a really nice way to make quick reports.
It's not only nice it's actually really really powerful.
Some people with you know all the time I do it when I need it and when I need it.
I love it.
I show you what to do.
For example in your report you want to overview some of all serve us combined with hardware costs.
You know we had that before we do that with some if we can do everything with the formula but sometimes
people Tabor's just the best thing.
So I select the whole thing here including the headings.
No way at a pivot table.
This is really different in every extraversion in most versions it's somewhere here like include or
something and then pivot table.
Here in my version it's under our data and people table.
Please google it if you have to extraversion Please insert pivot table but it's not really a problem.
So import table then it asks me which range to take.
I already selected it and then do it into a new worksheet.
So then the values only hit OK.
So now it made a new sheet as you see.
And this is so cool.
I can now just track things here as rows and columns and then look what happens in my version.
This is black and gray most versions.
This is white but it makes no difference for the functionality.
For example I want the type here rolls.
You see it automatically saw red and serve us.
And then I want to have the hardware costs here and it makes some off hardware costs automatically in
most versions.
It's not some it's the count of hardware cost.
Then you please have to change it.
You do hear the right click.
And then here are some count rich whatever.
OK.
Really important.
And you extraversion most likely you have counted less than that.
But I have some as the Senate count is the number of lines actually you see 74 serve us 78 Wrex but
I don't want to know how often the hardware costs as a few as they are of course.
I want to have some I want to see some of it.
You know these numbers already from the other electrons.
He has eight million whatever and seven million and here something interesting blank.
So that's one where neither wreck nor server is in this column.
You see here blank.
So you can use pivot tables also very easily to find arrows because it's not allowed to have a blank
here type was required.
I call that quality assurance was when I used that.
So with the war we found very easily with a table that we have values with playing.
It's interesting.
And I can even that's really cool.
You know that this is this was 47 or whatever lines are condensed to one line I can double click on
the value and Exodus automatically create a table with the underlying data.
This is so cool.
So I make the pivot table how I want to see it and then I can double click it and I see for example
here this line where the arrow works.
What you also have to know is when you update the underlying data.
For example you make this Suppe type server.
It's not directly in the pivot table I have to update the pivot table for example.
Right click and refresh data didn't work.
Let me go back.
I didn't type partir and type I did type and subtype.
So please let me move that from here to here.
Server.
Now I go back to the pool table.
I refresh it.
And so you see automatically condensed.
Really cool.
Let me undo that because I wanted to save that for you and the original state so you can see it.
You can do like anything with these people table.
You just have to play with them you just have to try it.
For example I can do the system ID here as a second value looks completely different.
Now I have every system my ID on it's own or you can say I want to group them by.
I don't know for example if this is really to us a year.
It would make sense to have it as a column.
Now it's about to break.
It's not looking nice anymore.
But imagine you have only 2014 2015 whatever.
It's really nice.
It would make a really nice table.
Or you can say I do this as a filter because I know the system my DS and I select only a couple of them
and then you know it's only a part of the whole thing.
So pure tables stop playing with it.
Please try it.
It's so nice.
You will absolutely love it.