Newbie: Auto Updating database Files ?

Hi Bigroo;
Thanks for this helpful suggestion. that Sounds exactly what I need, I will read in detail about the pivot tables.
what I get from your changes is that you first sorted by country name, then by unit type, then by unit build, name and retire. the Total Result shows the Total capacity of that unit.
1. for now, can I also add e.g the count of gas units and average unit efficiency per gas_unit class to this pivot table and so on.
2. can the same process be done to a database file containing more countries with the same fields and can be sorted out in the same manner.

Pivot Table, That's exactly what I needed, Thanks A lot dear.

Have wonderful day

Best Regards

Originally Posted by bigroo1958

Luckyali,

How does this look, a quick pivot table will give you the answers need!
On sheet1, I have created a table which is linked to the pivot table, just add to the bottom and your data will refresh.

HI bigroo, one more related question:

in the pivot table as you have arranged selected things in separate columns. Now can I sort the year and capacity per range. e.g in year 1970-1990 and rang of capacity between 0-300 or something like this. I had a look on group elements and slicers but could not get them easily.. any good tip in this regards.