Pivot table Totals

[EGilbert]

I have a question about Pivot tables.  I am doing an analysis by region for some plants and I have a number of different capacities in my file.  i need to select the lowest capacity listed for each plant.  I then need to sum those capacities to get a total capacity by year.  i have built the pivot table below and i get the mins fine but when it sums it follows the expression and shows the min value, rather than adding them together

How can I add the calculated mins together.  The expression I used for the mins is : 

min({$<[Capacity Type E]={"Installed"}>}[Harbour Capacity])

I tried dimension() but could not get the totals to work as it just keeps adding all the other values not shown as well.

[petter]

Have a look at this post which explains the solution to address you problem very well:

https://community.qlik.com/t5/QlikView-Documents/Sum-of-Rows-and-Expression-Total-Difference/ta-p/14...

There is an attached QlikView application within the article  as well.

Here is a screenshot of the main sheet:

[EGilbert]

Thanks for the reply

[EGilbert · Accepted solution]

I was able to get the solution to work with the use of Dimensionality.  Thanks all who replied